blob: b14234dce400c6ef1f95f4572fe423f2a7ef2717 (
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
|
drop table Ӌ��C���Z;
create table Ӌ��C���Z (���Z text, ����`�� varchar, �俼1A���� char(16));
create index Ӌ��C���Zindex1 on Ӌ��C���Z using btree (���Z);
create index Ӌ��C���Zindex2 on Ӌ��C���Z using hash (����`��);
insert into Ӌ��C���Z values('����ԥ�`���ǥ����ץ쥤','�CA01��');
insert into Ӌ��C���Z values('����ԥ�`������ե��å���','��B10��');
insert into Ӌ��C���Z values('����ԥ�`���ץ�����ީ`','��Z01��');
vacuum Ӌ��C���Z;
select * from Ӌ��C���Z;
���Z | ����`�� | �俼1a����
----------------------------+------------+------------
����ԥ�`���ǥ����ץ쥤 | �CA01�� |
����ԥ�`������ե��å��� | ��B10�� |
����ԥ�`���ץ�����ީ` | ��Z01�� |
(3 rows)
select * from Ӌ��C���Z where ����`�� = '��Z01��';
���Z | ����`�� | �俼1a����
--------------------------+------------+------------
����ԥ�`���ץ�����ީ` | ��Z01�� |
(1 row)
select * from Ӌ��C���Z where ����`�� ~* '��z01��';
���Z | ����`�� | �俼1a����
--------------------------+------------+------------
����ԥ�`���ץ�����ީ` | ��Z01�� |
(1 row)
select * from Ӌ��C���Z where ����`�� like '_Z01_';
���Z | ����`�� | �俼1a����
--------------------------+------------+------------
����ԥ�`���ץ�����ީ` | ��Z01�� |
(1 row)
select * from Ӌ��C���Z where ����`�� like '_Z%';
���Z | ����`�� | �俼1a����
--------------------------+------------+------------
����ԥ�`���ץ�����ީ` | ��Z01�� |
(1 row)
select * from Ӌ��C���Z where ���Z ~ '����ԥ�`��[�ǥ�]';
���Z | ����`�� | �俼1a����
----------------------------+------------+------------
����ԥ�`���ǥ����ץ쥤 | �CA01�� |
����ԥ�`������ե��å��� | ��B10�� |
(2 rows)
select * from Ӌ��C���Z where ���Z ~* '����ԥ�`��[�ǥ�]';
���Z | ����`�� | �俼1a����
----------------------------+------------+------------
����ԥ�`���ǥ����ץ쥤 | �CA01�� |
����ԥ�`������ե��å��� | ��B10�� |
(2 rows)
select *,character_length(���Z) from Ӌ��C���Z;
���Z | ����`�� | �俼1a���� | character_length
----------------------------+------------+------------+------------------
����ԥ�`���ǥ����ץ쥤 | �CA01�� | | 12
����ԥ�`������ե��å��� | ��B10�� | | 13
����ԥ�`���ץ�����ީ` | ��Z01�� | | 12
(3 rows)
select *,octet_length(���Z) from Ӌ��C���Z;
���Z | ����`�� | �俼1a���� | octet_length
----------------------------+------------+------------+--------------
����ԥ�`���ǥ����ץ쥤 | �CA01�� | | 36
����ԥ�`������ե��å��� | ��B10�� | | 39
����ԥ�`���ץ�����ީ` | ��Z01�� | | 36
(3 rows)
select *,position('��' in ���Z) from Ӌ��C���Z;
���Z | ����`�� | �俼1a���� | position
----------------------------+------------+------------+----------
����ԥ�`���ǥ����ץ쥤 | �CA01�� | | 7
����ԥ�`������ե��å��� | ��B10�� | | 0
����ԥ�`���ץ�����ީ` | ��Z01�� | | 0
(3 rows)
select *,substring(���Z from 10 for 4) from Ӌ��C���Z;
���Z | ����`�� | �俼1a���� | substring
----------------------------+------------+------------+-----------
����ԥ�`���ǥ����ץ쥤 | �CA01�� | | �ץ쥤
����ԥ�`������ե��å��� | ��B10�� | | ���å���
����ԥ�`���ץ�����ީ` | ��Z01�� | | ��ީ`
(3 rows)
|
