blob: 0ca86167ece0fd667b31cd492b3fe7d3741df251 (
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
|
QUERY: drop table �t�Ӹ��;
QUERY: create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16));
QUERY: create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O);
QUERY: create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y);
QUERY: insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��');
QUERY: insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��');
QUERY: insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E');
QUERY: vacuum �t�Ӹ��;
QUERY: select * from �t�Ӹ��;
��~�O|���q���Y |�a�}
------+----------------+-------
�q���~|�F�F��� |�_A01��
�s�y�~|�]���������q |��B10��
�\���~|�����ѥ��������q|��Z01�E
(3 rows)
QUERY: select * from �t�Ӹ�� where �a�} = '��Z01�E';
��~�O|���q���Y |�a�}
------+----------------+-------
�\���~|�����ѥ��������q|��Z01�E
(1 row)
QUERY: select * from �t�Ӹ�� where �a�} ~* '��z01�E';
��~�O|���q���Y |�a�}
------+----------------+-------
�\���~|�����ѥ��������q|��Z01�E
(1 row)
QUERY: select * from �t�Ӹ�� where �a�} like '_Z01_';
��~�O|���q���Y |�a�}
------+----------------+-------
�\���~|�����ѥ��������q|��Z01�E
(1 row)
QUERY: select * from �t�Ӹ�� where �a�} like '_Z%';
��~�O|���q���Y |�a�}
------+----------------+-------
�\���~|�����ѥ��������q|��Z01�E
(1 row)
QUERY: select * from �t�Ӹ�� where ���q���Y ~ '�F�F��[�H�O��]';
��~�O|���q���Y|�a�}
------+--------+-------
�q���~|�F�F���|�_A01��
(1 row)
QUERY: select * from �t�Ӹ�� where ���q���Y ~* '�F�F��[�H�O��]';
��~�O|���q���Y|�a�}
------+--------+-------
�q���~|�F�F���|�_A01��
(1 row)
QUERY: select *, character_length(��~�O) from �t�Ӹ��;
��~�O|���q���Y |�a�} |length
------+----------------+-------+------
�q���~|�F�F��� |�_A01��| 3
�s�y�~|�]���������q |��B10��| 3
�\���~|�����ѥ��������q|��Z01�E| 3
(3 rows)
QUERY: select *, octet_length(��~�O) from �t�Ӹ��;
��~�O|���q���Y |�a�} |octet_length
------+----------------+-------+------------
�q���~|�F�F��� |�_A01��| 6
�s�y�~|�]���������q |��B10��| 6
�\���~|�����ѥ��������q|��Z01�E| 6
(3 rows)
QUERY: select *, position('����' in ���q���Y) from �t�Ӹ��;
��~�O|���q���Y |�a�} |strpos
------+----------------+-------+------
�q���~|�F�F��� |�_A01��| 0
�s�y�~|�]���������q |��B10��| 3
�\���~|�����ѥ��������q|��Z01�E| 5
(3 rows)
QUERY: select *, substring(���q���Y from 3 for 6 ) from �t�Ӹ��;
��~�O|���q���Y |�a�} |substr
------+----------------+-------+------------
�q���~|�F�F��� |�_A01��|���
�s�y�~|�]���������q |��B10��|�������q
�\���~|�����ѥ��������q|��Z01�E|�ѥ��������q
(3 rows)
|
