src/test/mb/expected/euc_cn.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 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ÉÏ |        |           10
 µçÄÔͼÐÎ   | ·ÖB01ÖÐ |        |            8
 µçÄÔ³ÌÐòÔ± | ÈËZ01Ï |        |           10
(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)