|
1 | | -QUERY:drop table �����Ѹ�; |
| 1 | +drop table �����Ѹ�; |
2 | 2 | ERROR: Relation '�����Ѹ�' does not exist |
3 | | -QUERY:create table �����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(16)); |
4 | | -QUERY:create index �����Ѹ�index1 on �����Ѹ� using btree (�Ѹ�); |
5 | | -QUERY:create index �����Ѹ�index2 on �����Ѹ� using hash (ʬ�ॳ����); |
6 | | -QUERY:insert into �����Ѹ� values('����ԥ塼���ǥ����ץ쥤','��A01��'); |
7 | | -QUERY:insert into �����Ѹ� values('����ԥ塼������ե��å���','ʬB10��'); |
8 | | -QUERY:insert into �����Ѹ� values('����ԥ塼���ץ�����ޡ�','��Z01��'); |
9 | | -QUERY:vacuum �����Ѹ�; |
10 | | -QUERY:select * from �����Ѹ�; |
11 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
12 | | ---------------------------+----------+---------- |
13 | | -����ԥ塼���ǥ����ץ쥤|��A01��| |
14 | | -����ԥ塼������ե��å���|ʬB10��| |
15 | | -����ԥ塼���ץ�����ޡ�|��Z01��| |
| 3 | +create table �����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(16)); |
| 4 | +create index �����Ѹ�index1 on �����Ѹ� using btree (�Ѹ�); |
| 5 | +create index �����Ѹ�index2 on �����Ѹ� using hash (ʬ�ॳ����); |
| 6 | +insert into �����Ѹ� values('����ԥ塼���ǥ����ץ쥤','��A01��'); |
| 7 | +insert into �����Ѹ� values('����ԥ塼������ե��å���','ʬB10��'); |
| 8 | +insert into �����Ѹ� values('����ԥ塼���ץ�����ޡ�','��Z01��'); |
| 9 | +vacuum �����Ѹ�; |
| 10 | +select * from �����Ѹ�; |
| 11 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 12 | +----------------------------+------------+------------ |
| 13 | +����ԥ塼���ǥ����ץ쥤 |��A01�� | |
| 14 | +����ԥ塼������ե��å��� |ʬB10�� | |
| 15 | +����ԥ塼���ץ�����ޡ� |��Z01�� | |
16 | 16 | (3 rows) |
17 | 17 |
|
18 | | -QUERY:select * from �����Ѹ� where ʬ�ॳ���� = '��Z01��'; |
19 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
20 | | -------------------------+----------+---------- |
21 | | -����ԥ塼���ץ�����ޡ�|��Z01��| |
| 18 | +select * from �����Ѹ� where ʬ�ॳ���� = '��Z01��'; |
| 19 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 20 | +--------------------------+------------+------------ |
| 21 | +����ԥ塼���ץ�����ޡ� |��Z01�� | |
22 | 22 | (1 row) |
23 | 23 |
|
24 | | -QUERY:select * from �����Ѹ� where ʬ�ॳ���� ~* '��z01��'; |
25 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
26 | | -------------------------+----------+---------- |
27 | | -����ԥ塼���ץ�����ޡ�|��Z01��| |
| 24 | +select * from �����Ѹ� where ʬ�ॳ���� ~* '��z01��'; |
| 25 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 26 | +--------------------------+------------+------------ |
| 27 | +����ԥ塼���ץ�����ޡ� |��Z01�� | |
28 | 28 | (1 row) |
29 | 29 |
|
30 | | -QUERY:select * from �����Ѹ� where ʬ�ॳ���� like '_Z01_'; |
31 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
32 | | -------------------------+----------+---------- |
33 | | -����ԥ塼���ץ�����ޡ�|��Z01��| |
| 30 | +select * from �����Ѹ� where ʬ�ॳ���� like '_Z01_'; |
| 31 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 32 | +--------------------------+------------+------------ |
| 33 | +����ԥ塼���ץ�����ޡ� |��Z01�� | |
34 | 34 | (1 row) |
35 | 35 |
|
36 | | -QUERY:select * from �����Ѹ� where ʬ�ॳ���� like '_Z%'; |
37 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
38 | | -------------------------+----------+---------- |
39 | | -����ԥ塼���ץ�����ޡ�|��Z01��| |
| 36 | +select * from �����Ѹ� where ʬ�ॳ���� like '_Z%'; |
| 37 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 38 | +--------------------------+------------+------------ |
| 39 | +����ԥ塼���ץ�����ޡ� |��Z01�� | |
40 | 40 | (1 row) |
41 | 41 |
|
42 | | -QUERY:select * from �����Ѹ� where �Ѹ� ~ '����ԥ塼��[�ǥ�]'; |
43 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
44 | | ---------------------------+----------+---------- |
45 | | -����ԥ塼���ǥ����ץ쥤|��A01��| |
46 | | -����ԥ塼������ե��å���|ʬB10��| |
| 42 | +select * from �����Ѹ� where �Ѹ� ~ '����ԥ塼��[�ǥ�]'; |
| 43 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 44 | +----------------------------+------------+------------ |
| 45 | +����ԥ塼���ǥ����ץ쥤 |��A01�� | |
| 46 | +����ԥ塼������ե��å��� |ʬB10�� | |
47 | 47 | (2 rows) |
48 | 48 |
|
49 | | -QUERY:select * from �����Ѹ� where �Ѹ� ~* '����ԥ塼��[�ǥ�]'; |
50 | | -�Ѹ�|ʬ�ॳ����|����1a���� |
51 | | ---------------------------+----------+---------- |
52 | | -����ԥ塼���ǥ����ץ쥤|��A01��| |
53 | | -����ԥ塼������ե��å���|ʬB10��| |
| 49 | +select * from �����Ѹ� where �Ѹ� ~* '����ԥ塼��[�ǥ�]'; |
| 50 | +�Ѹ� |ʬ�ॳ���� |����1a���� |
| 51 | +----------------------------+------------+------------ |
| 52 | +����ԥ塼���ǥ����ץ쥤 |��A01�� | |
| 53 | +����ԥ塼������ե��å��� |ʬB10�� | |
54 | 54 | (2 rows) |
55 | 55 |
|
56 | | -QUERY:select *,character_length(�Ѹ�) from �����Ѹ�; |
57 | | -�Ѹ�|ʬ�ॳ����|����1a����|length |
58 | | ---------------------------+----------+----------+------ |
59 | | -����ԥ塼���ǥ����ץ쥤|��A01�� || 12 |
60 | | -����ԥ塼������ե��å���|ʬB10�� || 13 |
61 | | -����ԥ塼���ץ�����ޡ�|��Z01�� || 12 |
| 56 | +select *,character_length(�Ѹ�) from �����Ѹ�; |
| 57 | +�Ѹ� |ʬ�ॳ���� |����1a���� |length |
| 58 | +----------------------------+------------+------------+-------- |
| 59 | +����ԥ塼���ǥ����ץ쥤 |��A01��| | 12 |
| 60 | +����ԥ塼������ե��å��� |ʬB10��| | 13 |
| 61 | +����ԥ塼���ץ�����ޡ� |��Z01��| | 12 |
62 | 62 | (3 rows) |
63 | 63 |
|
64 | | -QUERY:select *,octet_length(�Ѹ�) from �����Ѹ�; |
65 | | -�Ѹ�|ʬ�ॳ����|����1a����|octet_length |
66 | | ---------------------------+----------+----------+------------ |
67 | | -����ԥ塼���ǥ����ץ쥤|��A01�� || 24 |
68 | | -����ԥ塼������ե��å���|ʬB10�� || 26 |
69 | | -����ԥ塼���ץ�����ޡ�|��Z01�� || 24 |
| 64 | +select *,octet_length(�Ѹ�) from �����Ѹ�; |
| 65 | +�Ѹ� |ʬ�ॳ���� |����1a���� |octet_length |
| 66 | +----------------------------+------------+------------+-------------- |
| 67 | +����ԥ塼���ǥ����ץ쥤 |��A01��| | 24 |
| 68 | +����ԥ塼������ե��å��� |ʬB10��| | 26 |
| 69 | +����ԥ塼���ץ�����ޡ� |��Z01��| | 24 |
70 | 70 | (3 rows) |
71 | 71 |
|
72 | | -QUERY:select *,position('��' in �Ѹ�) from �����Ѹ�; |
73 | | -�Ѹ�|ʬ�ॳ����|����1a����|strpos |
74 | | ---------------------------+----------+----------+------ |
75 | | -����ԥ塼���ǥ����ץ쥤|��A01�� || 7 |
76 | | -����ԥ塼������ե��å���|ʬB10�� || 0 |
77 | | -����ԥ塼���ץ�����ޡ�|��Z01�� || 0 |
| 72 | +select *,position('��' in �Ѹ�) from �����Ѹ�; |
| 73 | +�Ѹ� |ʬ�ॳ���� |����1a���� |strpos |
| 74 | +----------------------------+------------+------------+-------- |
| 75 | +����ԥ塼���ǥ����ץ쥤 |��A01��| | 7 |
| 76 | +����ԥ塼������ե��å��� |ʬB10��| | 0 |
| 77 | +����ԥ塼���ץ�����ޡ� |��Z01��| | 0 |
78 | 78 | (3 rows) |
79 | 79 |
|
80 | | -QUERY:select *,substring(�Ѹ� from 10 for 4) from �����Ѹ�; |
81 | | -�Ѹ�|ʬ�ॳ����|����1a����|substr |
82 | | ---------------------------+----------+----------+-------- |
83 | | -����ԥ塼���ǥ����ץ쥤|��A01�� ||�ץ쥤 |
84 | | -����ԥ塼������ե��å���|ʬB10�� ||���å��� |
85 | | -����ԥ塼���ץ�����ޡ�|��Z01�� ||��ޡ� |
| 80 | +select *,substring(�Ѹ� from 10 for 4) from �����Ѹ�; |
| 81 | +�Ѹ� |ʬ�ॳ���� |����1a���� |substr |
| 82 | +----------------------------+------------+------------+---------- |
| 83 | +����ԥ塼���ǥ����ץ쥤 |��A01��| |�ץ쥤 |
| 84 | +����ԥ塼������ե��å��� |ʬB10��| |���å��� |
| 85 | +����ԥ塼���ץ�����ޡ� |��Z01��| |��ޡ� |
86 | 86 | (3 rows) |
87 | 87 |
|