src/test/mb/expected/mule_internal.out

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’¾å    |            |               12
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ    |            |               13
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼   | ’¿ÍZ01’²¼    |            |               12
(3 rows)

select *,octet_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì;
            ’Íђ¸ì            | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | octet_length 
----------------------------+------------+------------+--------------
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤   | ’µ¡A01’¾å    |            |           36
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ    |            |           39
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼   | ’¿ÍZ01’²¼    |            |           36
(3 rows)

select *,position('’¥Ç' in ’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì;
            ’Íђ¸ì            | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | position 
----------------------------+------------+------------+----------
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤   | ’µ¡A01’¾å    |            |        7
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ    |            |        0
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼   | ’¿ÍZ01’²¼    |            |        0
(3 rows)

select *,substring(’Íђ¸ì from 10 for 4) from ’·×’»»’µ¡’Íђ¸ì;
            ’Íђ¸ì            | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substring 
----------------------------+------------+------------+-----------
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤   | ’µ¡A01’¾å    |            | ’¥×’¥ì’¥¤
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ    |            | ’¥£’¥Ã’¥¯’¥¹
 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼   | ’¿ÍZ01’²¼    |            | ’¥é’¥Þ’¡¼
(3 rows)

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 btree(‘·Ö‘Àà‘ºÅ);
insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘ÄԑÏԑʾ‘ÆÁ','‘»úA01‘ÉÏ');
insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘Äԑͼ‘ÐÎ','‘·ÖB01‘ÖÐ');
insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘Äԑ³Ì‘Ðò‘Ô±','‘ÈËZ01‘ÏÂ');
vacuum ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a 
------------+---------+--------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | 
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ | 
 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈË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‘ÉÏ | 
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ | 
(2 rows)

select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~* '‘µç‘ÄÔ[‘Ïԑͼ]';
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a 
------------+---------+--------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | 
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ | 
(2 rows)

select *,character_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a | character_length 
------------+---------+--------+------------------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ |        |                5
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ |        |                4
 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï |        |                5
(3 rows)

select *,octet_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a | octet_length 
------------+---------+--------+--------------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ |        |           15
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ |        |           12
 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï |        |           15
(3 rows)

select *,position('‘ÏÔ' in ‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a | position 
------------+---------+--------+----------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ |        |        3
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ |        |        0
 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï |        |        0
(3 rows)

select *,substring(‘Êõ‘Óï from 3 for 4) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï;
    ‘Êõ‘Óï    | ‘·Ö‘Àà‘ºÅ  | ‘±¸‘×¢1a | substring 
------------+---------+--------+-----------
 ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ |        | ‘Ïԑʾ‘ÆÁ
 ‘µç‘Äԑͼ‘ÐÎ   | ‘·ÖB01‘ÖÐ |        | ‘ͼ‘ÐÎ
 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï |        | ‘³Ì‘Ðò‘Ô±
(3 rows)

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“ß¾  |            |           24
 “Äēǻ“Å͓±×“·¡“Çȓ½º   | “ÝÂB10“ñé  |            |           21
 “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù»  |            |           24
(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)

drop table test;
ERROR:  table "test" does not exist
create table test (t text);
insert into test values('ENGLISH');
insert into test values('FRANÇAIS');
insert into test values('ESPAÑOL');
insert into test values('ÍSLENSKA');
insert into test values('ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA');
vacuum test;
select * from test;
                 t                 
-----------------------------------
 ENGLISH
 FRANÇAIS
 ESPAÑOL
 ÍSLENSKA
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA
(5 rows)

select * from test where t = 'ESPAÑOL';
    t    
---------
 ESPAÑOL
(1 row)

select * from test where t ~* 'espaÑol';
                 t                 
-----------------------------------
 ESPAÑOL
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA
(2 rows)

select *,character_length(t) from test;
                 t                 | character_length 
-----------------------------------+------------------
 ENGLISH                           |                7
 FRANÇAIS                          |                8
 ESPAÑOL                           |                7
 ÍSLENSKA                          |                8
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA |               33
(5 rows)

select *,octet_length(t) from test;
                 t                 | octet_length 
-----------------------------------+--------------
 ENGLISH                           |            7
 FRANÇAIS                          |            9
 ESPAÑOL                           |            8
 ÍSLENSKA                          |            9
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA |           36
(5 rows)

select *,position('L' in t) from test;
                 t                 | position 
-----------------------------------+----------
 ENGLISH                           |        4
 FRANÇAIS                          |        0
 ESPAÑOL                           |        7
 ÍSLENSKA                          |        3
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA |        4
(5 rows)

select *,substring(t from 3 for 4) from test;
                 t                 | substring 
-----------------------------------+-----------
 ENGLISH                           | GLIS
 FRANÇAIS                          | ANÇA
 ESPAÑOL                           | PAÑO
 ÍSLENSKA                          | LENS
 ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | GLIS
(5 rows)