blob: 702579eebaa192b8ef1446c2b2b08bc508fe7c82 (
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�} | 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�} | strpos
--------+------------------+---------+--------
�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�} | substr
--------+------------------+---------+--------------
�q���~ | �F�F��� | �_A01�� | ���
�s�y�~ | �]���������q | ��B10�� | �������q
�\���~ | �����ѥ��������q | ��Z01�E | �ѥ��������q
(3 rows)
|
