|
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߾ || 8 |
60 | | -��ǻ�ͱ��Ƚ�|��B10�� || 7 |
61 | | -��ǻ�����α���|��Z01�� || 8 |
| 56 | +select *,character_length(���) from ͪߩѦ���; |
| 57 | +��� |���ڵ� |���1a�� |length |
| 58 | +------------------+----------+------------+-------- |
| 59 | +��ǻ�͵��÷��� |ѦA01߾| | 8 |
| 60 | +��ǻ�ͱ��Ƚ� |��B10��| | 7 |
| 61 | +��ǻ�����α��� |��Z01��| | 8 |
62 | 62 | (3 rows) |
63 | 63 |
|
64 | | -QUERY:select *,octet_length(���) from ͪߩѦ���; |
65 | | -���|���ڵ�|���1a��|octet_length |
66 | | -----------------+--------+----------+------------ |
67 | | -��ǻ�͵��÷���|ѦA01߾ || 16 |
68 | | -��ǻ�ͱ��Ƚ�|��B10�� || 14 |
69 | | -��ǻ�����α���|��Z01�� || 16 |
| 64 | +select *,octet_length(���) from ͪߩѦ���; |
| 65 | +��� |���ڵ� |���1a�� |octet_length |
| 66 | +------------------+----------+------------+-------------- |
| 67 | +��ǻ�͵��÷��� |ѦA01߾| | 16 |
| 68 | +��ǻ�ͱ��Ƚ� |��B10��| | 14 |
| 69 | +��ǻ�����α��� |��Z01��| | 16 |
70 | 70 | (3 rows) |
71 | 71 |
|
72 | | -QUERY:select *,position('��' in ���) from ͪߩѦ���; |
73 | | -���|���ڵ�|���1a��|strpos |
74 | | -----------------+--------+----------+------ |
75 | | -��ǻ�͵��÷���|ѦA01߾ || 4 |
76 | | -��ǻ�ͱ��Ƚ�|��B10�� || 0 |
77 | | -��ǻ�����α���|��Z01�� || 0 |
| 72 | +select *,position('��' in ���) from ͪߩѦ���; |
| 73 | +��� |���ڵ� |���1a�� |strpos |
| 74 | +------------------+----------+------------+-------- |
| 75 | +��ǻ�͵��÷��� |ѦA01߾| | 4 |
| 76 | +��ǻ�ͱ��Ƚ� |��B10��| | 0 |
| 77 | +��ǻ�����α��� |��Z01��| | 0 |
78 | 78 | (3 rows) |
79 | 79 |
|
80 | | -QUERY:select *,substring(��� from 3 for 4) from ͪߩѦ���; |
81 | | -���|���ڵ�|���1a��|substr |
82 | | -----------------+--------+----------+-------- |
83 | | -��ǻ�͵��÷���|ѦA01߾ ||�͵��� |
84 | | -��ǻ�ͱ��Ƚ�|��B10�� ||�ͱ��� |
85 | | -��ǻ�����α���|��Z01�� ||�����α� |
| 80 | +select *,substring(��� from 3 for 4) from ͪߩѦ���; |
| 81 | +��� |���ڵ� |���1a�� |substr |
| 82 | +------------------+----------+------------+---------- |
| 83 | +��ǻ�͵��÷��� |ѦA01߾| |�͵��� |
| 84 | +��ǻ�ͱ��Ƚ� |��B10��| |�ͱ��� |
| 85 | +��ǻ�����α��� |��Z01��| |�����α� |
86 | 86 | (3 rows) |
87 | 87 |
|