|
1 | | -QUERY:drop table �t�Ӹ��; |
2 | | -QUERY:create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16)); |
3 | | -QUERY:create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O); |
4 | | -QUERY:create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y); |
5 | | -QUERY:insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��'); |
6 | | -QUERY:insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��'); |
7 | | -QUERY:insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E'); |
8 | | -QUERY:vacuum �t�Ӹ��; |
9 | | -QUERY:select * from �t�Ӹ��; |
10 | | -��~�O|���q���Y |�a�} |
11 | | -------+----------------+------- |
12 | | -�q���~|�F�F���|�_A01�� |
13 | | -�s�y�~|�]���������q|��B10�� |
14 | | -�\���~|�����ѥ��������q|��Z01�E |
| 1 | +drop table �t�Ӹ�� |
| 2 | +create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16)) |
| 3 | +create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O) |
| 4 | +create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y) |
| 5 | +insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��') |
| 6 | +insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��') |
| 7 | +insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E') |
| 8 | +vacuum �t�Ӹ�� |
| 9 | +select * from �t�Ӹ�� |
| 10 | +��~�O |���q���Y|�a�} |
| 11 | +--------+------------------+--------- |
| 12 | +�q���~ |�F�F��� |�_A01�� |
| 13 | +�s�y�~ |�]���������q |��B10�� |
| 14 | +�\���~ |�����ѥ��������q |��Z01�E |
15 | 15 | (3 rows) |
16 | 16 |
|
17 | | -QUERY:select * from �t�Ӹ�� where �a�} = '��Z01�E'; |
18 | | -��~�O|���q���Y |�a�} |
19 | | -------+----------------+------- |
20 | | -�\���~|�����ѥ��������q|��Z01�E |
| 17 | +select * from �t�Ӹ�� where �a�} = '��Z01�E' |
| 18 | +��~�O |���q���Y|�a�} |
| 19 | +--------+------------------+--------- |
| 20 | +�\���~ |�����ѥ��������q |��Z01�E |
21 | 21 | (1 row) |
22 | 22 |
|
23 | | -QUERY:select * from �t�Ӹ�� where �a�} ~* '��z01�E'; |
24 | | -��~�O|���q���Y |�a�} |
25 | | -------+----------------+------- |
26 | | -�\���~|�����ѥ��������q|��Z01�E |
| 23 | +select * from �t�Ӹ�� where �a�} ~* '��z01�E' |
| 24 | +��~�O |���q���Y|�a�} |
| 25 | +--------+------------------+--------- |
| 26 | +�\���~ |�����ѥ��������q |��Z01�E |
27 | 27 | (1 row) |
28 | 28 |
|
29 | | -QUERY:select * from �t�Ӹ�� where �a�} like '_Z01_'; |
30 | | -��~�O|���q���Y |�a�} |
31 | | -------+----------------+------- |
32 | | -�\���~|�����ѥ��������q|��Z01�E |
| 29 | +select * from �t�Ӹ�� where �a�} like '_Z01_' |
| 30 | +��~�O |���q���Y|�a�} |
| 31 | +--------+------------------+--------- |
| 32 | +�\���~ |�����ѥ��������q |��Z01�E |
33 | 33 | (1 row) |
34 | 34 |
|
35 | | -QUERY:select * from �t�Ӹ�� where �a�} like '_Z%'; |
36 | | -��~�O|���q���Y |�a�} |
37 | | -------+----------------+------- |
38 | | -�\���~|�����ѥ��������q|��Z01�E |
| 35 | +select * from �t�Ӹ�� where �a�} like '_Z%' |
| 36 | +��~�O |���q���Y|�a�} |
| 37 | +--------+------------------+--------- |
| 38 | +�\���~ |�����ѥ��������q |��Z01�E |
39 | 39 | (1 row) |
40 | 40 |
|
41 | | -QUERY:select * from �t�Ӹ�� where ���q���Y ~ '�F�F��[�H�O��]'; |
42 | | -��~�O|���q���Y|�a�} |
43 | | -------+--------+------- |
44 | | -�q���~|�F�F���|�_A01�� |
| 41 | +select * from �t�Ӹ�� where ���q���Y ~ '�F�F��[�H�O��]' |
| 42 | +��~�O |���q���Y |�a�} |
| 43 | +--------+----------+--------- |
| 44 | +�q���~ |�F�F��� |�_A01�� |
45 | 45 | (1 row) |
46 | 46 |
|
47 | | -QUERY:select * from �t�Ӹ�� where ���q���Y ~* '�F�F��[�H�O��]'; |
48 | | -��~�O|���q���Y|�a�} |
49 | | -------+--------+------- |
50 | | -�q���~|�F�F���|�_A01�� |
| 47 | +select * from �t�Ӹ�� where ���q���Y ~* '�F�F��[�H�O��]' |
| 48 | +��~�O |���q���Y |�a�} |
| 49 | +--------+----------+--------- |
| 50 | +�q���~ |�F�F��� |�_A01�� |
51 | 51 | (1 row) |
52 | 52 |
|
53 | | -QUERY:select *, character_length(��~�O) from �t�Ӹ��; |
54 | | -��~�O|���q���Y |�a�} |length |
55 | | -------+----------------+-------+------ |
56 | | -�q���~|�F�F���|�_A01��| 3 |
57 | | -�s�y�~|�]���������q|��B10��| 3 |
58 | | -�\���~|�����ѥ��������q|��Z01�E| 3 |
| 53 | +select *, character_length(��~�O) from �t�Ӹ�� |
| 54 | +��~�O |���q���Y|�a�} |length |
| 55 | +--------+------------------+---------+-------- |
| 56 | +�q���~ |�F�F��� |�_A01�� | 3 |
| 57 | +�s�y�~ |�]���������q |��B10�� | 3 |
| 58 | +�\���~ |�����ѥ��������q |��Z01�E | 3 |
59 | 59 | (3 rows) |
60 | 60 |
|
61 | | -QUERY:select *, octet_length(��~�O) from �t�Ӹ��; |
62 | | -��~�O|���q���Y |�a�} |octet_length |
63 | | -------+----------------+-------+------------ |
64 | | -�q���~|�F�F���|�_A01��| 6 |
65 | | -�s�y�~|�]���������q|��B10��| 6 |
66 | | -�\���~|�����ѥ��������q|��Z01�E| 6 |
| 61 | +select *, octet_length(��~�O) from �t�Ӹ�� |
| 62 | +��~�O |���q���Y|�a�} |octet_length |
| 63 | +--------+------------------+---------+-------------- |
| 64 | +�q���~ |�F�F��� |�_A01�� | 6 |
| 65 | +�s�y�~ |�]���������q |��B10�� | 6 |
| 66 | +�\���~ |�����ѥ��������q |��Z01�E | 6 |
67 | 67 | (3 rows) |
68 | 68 |
|
69 | | -QUERY:select *, position('����' in ���q���Y) from �t�Ӹ��; |
70 | | -��~�O|���q���Y |�a�} |strpos |
71 | | -------+----------------+-------+------ |
72 | | -�q���~|�F�F���|�_A01��| 0 |
73 | | -�s�y�~|�]���������q|��B10��| 3 |
74 | | -�\���~|�����ѥ��������q|��Z01�E| 5 |
| 69 | +select *, position('����' in ���q���Y) from �t�Ӹ�� |
| 70 | +��~�O |���q���Y|�a�} |strpos |
| 71 | +--------+------------------+---------+-------- |
| 72 | +�q���~ |�F�F��� |�_A01�� | 0 |
| 73 | +�s�y�~ |�]���������q |��B10�� | 3 |
| 74 | +�\���~ |�����ѥ��������q |��Z01�E | 5 |
75 | 75 | (3 rows) |
76 | 76 |
|
77 | | -QUERY:select *, substring(���q���Y from 3 for 6 ) from �t�Ӹ��; |
78 | | -��~�O|���q���Y |�a�} |substr |
79 | | -------+----------------+-------+------------ |
80 | | -�q���~|�F�F���|�_A01��|��� |
81 | | -�s�y�~|�]���������q|��B10��|�������q |
82 | | -�\���~|�����ѥ��������q|��Z01�E|�ѥ��������q |
| 77 | +select *, substring(���q���Y from 3 for 6 ) from �t�Ӹ�� |
| 78 | +��~�O |���q���Y|�a�} | substr |
| 79 | +--------+------------------+---------+-------------- |
| 80 | +�q���~ |�F�F��� |�_A01�� |��� |
| 81 | +�s�y�~ |�]���������q |��B10�� |�������q |
| 82 | +�\���~ |�����ѥ��������q |��Z01�E |�ѥ��������q |
83 | 83 | (3 rows) |
84 | 84 |
|