src/test/mb/expected/euc_kr.out


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
86
87

drop table 悠潯僞遂嬢;
ERROR:  table "悠潯僞遂嬢" does not exist
create table 悠潯僞遂嬢 (遂嬢 text, 歛彎坪球 varchar, 搾壱1A虞姥 char(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 悠潯僞遂嬢;
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗巨什巴傾戚 | 僞A01濔  | 
 陳濃斗益掘波什   | 歛B10驩  | 
 陳濃斗覗稽益掘袴 | 賺Z01俿  | 
(3 rows)

select * from 悠潯僞遂嬢 where 歛彎坪球 = '賺Z01俿';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗覗稽益掘袴 | 賺Z01俿  | 
(1 row)

select * from 悠潯僞遂嬢 where 歛彎坪球 ~* '賺z01俿';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗覗稽益掘袴 | 賺Z01俿  | 
(1 row)

select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z01_';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗覗稽益掘袴 | 賺Z01俿  | 
(1 row)

select * from 悠潯僞遂嬢 where 歛彎坪球 like '_Z%';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗覗稽益掘袴 | 賺Z01俿  | 
(1 row)

select * from 悠潯僞遂嬢 where 遂嬢 ~ '陳濃斗[巨益]';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗巨什巴傾戚 | 僞A01濔  | 
 陳濃斗益掘波什   | 歛B10驩  | 
(2 rows)

select * from 悠潯僞遂嬢 where 遂嬢 ~* '陳濃斗[巨益]';
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 
------------------+----------+------------
 陳濃斗巨什巴傾戚 | 僞A01濔  | 
 陳濃斗益掘波什   | 歛B10驩  | 
(2 rows)

select *,character_length(遂嬢) from 悠潯僞遂嬢;
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 | character_length 
------------------+----------+------------+------------------
 陳濃斗巨什巴傾戚 | 僞A01濔  |            |                8
 陳濃斗益掘波什   | 歛B10驩  |            |                7
 陳濃斗覗稽益掘袴 | 賺Z01俿  |            |                8
(3 rows)

select *,octet_length(遂嬢) from 悠潯僞遂嬢;
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 | octet_length 
------------------+----------+------------+--------------
 陳濃斗巨什巴傾戚 | 僞A01濔  |            |           16
 陳濃斗益掘波什   | 歛B10驩  |            |           14
 陳濃斗覗稽益掘袴 | 賺Z01俿  |            |           16
(3 rows)

select *,position('巨' in 遂嬢) from 悠潯僞遂嬢;
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 | position 
------------------+----------+------------+----------
 陳濃斗巨什巴傾戚 | 僞A01濔  |            |        4
 陳濃斗益掘波什   | 歛B10驩  |            |        0
 陳濃斗覗稽益掘袴 | 賺Z01俿  |            |        0
(3 rows)

select *,substring(遂嬢 from 3 for 4) from 悠潯僞遂嬢;
       遂嬢       | 歛彎坪球 | 搾壱1a虞姥 | substring 
------------------+----------+------------+-----------
 陳濃斗巨什巴傾戚 | 僞A01濔  |            | 斗巨什巴
 陳濃斗益掘波什   | 歛B10驩  |            | 斗益掘波
 陳濃斗覗稽益掘袴 | 賺Z01俿  |            | 斗覗稽益
(3 rows)