2
ERROR: Relation '��ٸ����' does not exist
3
create table ��ٸ���� (����ɱ text, ��Ƴ��� varchar, ���� varchar(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Ħ');
10
select * from ��ٸ����;
12
--------+------------------+---------
13
����� | ������ | ơA01��
14
������ | ����ȴ����Ƴ | ��B10��
15
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ
18
select * from ��ٸ���� where ���� = '��Z01Ħ';
20
--------+------------------+---------
21
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ
24
select * from ��ٸ���� where ���� ~* '��z01Ħ';
26
--------+------------------+---------
27
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ
30
select * from ��ٸ���� where ���� like '_Z01_';
32
--------+------------------+---------
33
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ
36
select * from ��ٸ���� where ���� like '_Z%';
38
--------+------------------+---------
39
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ
42
select * from ��ٸ���� where ��Ƴ��� ~ '����[��ش��]';
44
--------+----------+---------
45
����� | ������ | ơA01��
48
select * from ��ٸ���� where ��Ƴ��� ~* '����[��ش��]';
50
--------+----------+---------
51
����� | ������ | ơA01��
54
select *, character_length(����ɱ) from ��ٸ����;
55
����ɱ | ��Ƴ��� | ���� | char_length
56
--------+------------------+---------+-------------
57
����� | ������ | ơA01�� | 3
58
������ | ����ȴ����Ƴ | ��B10�� | 3
59
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ | 3
62
select *, octet_length(����ɱ) from ��ٸ����;
63
����ɱ | ��Ƴ��� | ���� | octet_length
64
--------+------------------+---------+--------------
65
����� | ������ | ơA01�� | 6
66
������ | ����ȴ����Ƴ | ��B10�� | 6
67
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ | 6
70
select *, position('ȴ��' in ��Ƴ���) from ��ٸ����;
71
����ɱ | ��Ƴ��� | ���� | strpos
72
--------+------------------+---------+--------
73
����� | ������ | ơA01�� | 0
74
������ | ����ȴ����Ƴ | ��B10�� | 3
75
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ | 5
78
select *, substring(��Ƴ��� from 3 for 6 ) from ��ٸ����;
79
����ɱ | ��Ƴ��� | ���� | substr
80
--------+------------------+---------+--------------
81
����� | ������ | ơA01�� | ����
82
������ | ����ȴ����Ƴ | ��B10�� | ȴ����Ƴ
83
���� | ӡ��ϴǹȴ����Ƴ | ��Z01Ħ | ϴǹȴ����Ƴ