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