blob: db2bfd0d755ef11396df00242d6af51f6a62fa4a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
drop table �v�Z�@�p��;
create table �v�Z�@�p�� (�p�� text, ���ރR�[�h varchar, ���l1A���� char(16));
create index �v�Z�@�p��index1 on �v�Z�@�p�� using btree (�p��);
create index �v�Z�@�p��index2 on �v�Z�@�p�� using hash (���ރR�[�h);
insert into �v�Z�@�p�� values('�R���s���[�^�f�B�X�v���C','�@A01��');
insert into �v�Z�@�p�� values('�R���s���[�^�O���t�B�b�N�X','��B10��');
insert into �v�Z�@�p�� values('�R���s���[�^�v���O���}�[','�lZ01��');
vacuum �v�Z�@�p��;
select * from �v�Z�@�p��;
�p�� | ���ރR�[�h | ���l1a����
----------------------------+------------+------------
�R���s���[�^�f�B�X�v���C | �@A01�� |
�R���s���[�^�O���t�B�b�N�X | ��B10�� |
�R���s���[�^�v���O���}�[ | �lZ01�� |
(3 rows)
select * from �v�Z�@�p�� where ���ރR�[�h = '�lZ01��';
�p�� | ���ރR�[�h | ���l1a����
--------------------------+------------+------------
�R���s���[�^�v���O���}�[ | �lZ01�� |
(1 row)
select * from �v�Z�@�p�� where ���ރR�[�h ~* '�lz01��';
�p�� | ���ރR�[�h | ���l1a����
--------------------------+------------+------------
�R���s���[�^�v���O���}�[ | �lZ01�� |
(1 row)
select * from �v�Z�@�p�� where ���ރR�[�h like '_Z01_';
�p�� | ���ރR�[�h | ���l1a����
--------------------------+------------+------------
�R���s���[�^�v���O���}�[ | �lZ01�� |
(1 row)
select * from �v�Z�@�p�� where ���ރR�[�h like '_Z%';
�p�� | ���ރR�[�h | ���l1a����
--------------------------+------------+------------
�R���s���[�^�v���O���}�[ | �lZ01�� |
(1 row)
select * from �v�Z�@�p�� where �p�� ~ '�R���s���[�^[�f�O]';
�p�� | ���ރR�[�h | ���l1a����
----------------------------+------------+------------
�R���s���[�^�f�B�X�v���C | �@A01�� |
�R���s���[�^�O���t�B�b�N�X | ��B10�� |
(2 rows)
select * from �v�Z�@�p�� where �p�� ~* '�R���s���[�^[�f�O]';
�p�� | ���ރR�[�h | ���l1a����
----------------------------+------------+------------
�R���s���[�^�f�B�X�v���C | �@A01�� |
�R���s���[�^�O���t�B�b�N�X | ��B10�� |
(2 rows)
select *,character_length(�p��) from �v�Z�@�p��;
�p�� | ���ރR�[�h | ���l1a���� | character_length
----------------------------+------------+------------+------------------
�R���s���[�^�f�B�X�v���C | �@A01�� | | 12
�R���s���[�^�O���t�B�b�N�X | ��B10�� | | 13
�R���s���[�^�v���O���}�[ | �lZ01�� | | 12
(3 rows)
select *,octet_length(�p��) from �v�Z�@�p��;
�p�� | ���ރR�[�h | ���l1a���� | octet_length
----------------------------+------------+------------+--------------
�R���s���[�^�f�B�X�v���C | �@A01�� | | 24
�R���s���[�^�O���t�B�b�N�X | ��B10�� | | 26
�R���s���[�^�v���O���}�[ | �lZ01�� | | 24
(3 rows)
select *,position('�f' in �p��) from �v�Z�@�p��;
�p�� | ���ރR�[�h | ���l1a���� | position
----------------------------+------------+------------+----------
�R���s���[�^�f�B�X�v���C | �@A01�� | | 7
�R���s���[�^�O���t�B�b�N�X | ��B10�� | | 0
�R���s���[�^�v���O���}�[ | �lZ01�� | | 0
(3 rows)
select *,substring(�p�� from 10 for 4) from �v�Z�@�p��;
�p�� | ���ރR�[�h | ���l1a���� | substring
----------------------------+------------+------------+-----------
�R���s���[�^�f�B�X�v���C | �@A01�� | | �v���C
�R���s���[�^�O���t�B�b�N�X | ��B10�� | | �B�b�N�X
�R���s���[�^�v���O���}�[ | �lZ01�� | | ���}�[
(3 rows)
copy �v�Z�@�p�� to stdout;
�R���s���[�^�f�B�X�v���C �@A01�� \N
�R���s���[�^�O���t�B�b�N�X ��B10�� \N
�R���s���[�^�v���O���}�[ �lZ01�� \N
|
