blob: 99eb4884e12668fe9c4abbe0ab21bbf12fb2e697 (
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
85
|
drop table ìÞÙ¸æñÕè;
ERROR: table "ìÞÙ¸æñÕè" does not exist
create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(16));
create index ìÞÙ¸æñÕèindex1 on ìÞÙ¸æñÕè using btree (ÈçäÆɱ);
create index ìÞÙ¸æñÕèindex2 on ìÞÙ¸æñÕè using hash (ÄüƳÍñó¤);
insert into ìÞÙ¸æñÕè values ('çÙæªäÆ', 'ç®ç®ÒïÊÀ', 'Æ¡A01Äî');
insert into ìÞÙ¸æñÕè values ('êûÝßäÆ', 'ØÂäãÈ´ÓîÄüƳ', 'ÄãB10Äã');
insert into ìÞÙ¸æñÕè values ('ó§ã£äÆ', 'Ó¡ÌÀϴǹȴÓîÄüƳ', 'ØíZ01Ħ');
vacuum ìÞÙ¸æñÕè;
select * from ìÞÙ¸æñÕè;
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+------------------+---------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî
êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ
(3 rows)
select * from ìÞÙ¸æñÕè where ÇâÉß = 'ØíZ01Ħ';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+------------------+---------
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ
(1 row)
select * from ìÞÙ¸æñÕè where ÇâÉß ~* 'Øíz01Ħ';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+------------------+---------
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ
(1 row)
select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z01_';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+------------------+---------
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ
(1 row)
select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z%';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+------------------+---------
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ
(1 row)
select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~ 'ç®ç®Òï[ÙìØ´ÊÀ]';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+----------+---------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî
(1 row)
select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]';
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß
--------+----------+---------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî
(1 row)
select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè;
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | character_length
--------+------------------+---------+------------------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 3
êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 3
(3 rows)
select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè;
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | octet_length
--------+------------------+---------+--------------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 6
êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 6
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 6
(3 rows)
select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè;
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | position
--------+------------------+---------+----------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 0
êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 5
(3 rows)
select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè;
ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | substring
--------+------------------+---------+--------------
çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | ÒïÊÀ
êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | È´ÓîÄüƳ
ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | ϴǹȴÓîÄüƳ
(3 rows)
|
