drop table Ӌ��C���Z;
create table Ӌ��C���Z (���Z text, ����`�� varchar, �俼1A���� char(16));
create index Ӌ��C���Zindex1 on Ӌ��C���Z using btree (���Z);
create index Ӌ��C���Zindex2 on Ӌ��C���Z using hash (����`��);
insert into Ӌ��C���Z values('����ԥ�`���ǥ����ץ쥤','�CA01��');
insert into Ӌ��C���Z values('����ԥ�`������ե��å���','��B10��');
insert into Ӌ��C���Z values('����ԥ�`���ץ���ީ`','��Z01��');
vacuum Ӌ��C���Z;
select * from Ӌ��C���Z;
            ���Z            | ����`�� | �俼1a���� 
----------------------------+------------+------------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    | 
 ����ԥ�`������ե��å��� | ��B10��    | 
 ����ԥ�`���ץ���ީ`   | ��Z01��    | 
(3 rows)

select * from Ӌ��C���Z where ����`�� = '��Z01��';
           ���Z           | ����`�� | �俼1a���� 
--------------------------+------------+------------
 ����ԥ�`���ץ���ީ` | ��Z01��    | 
(1 row)

select * from Ӌ��C���Z where ����`�� ~* '��z01��';
           ���Z           | ����`�� | �俼1a���� 
--------------------------+------------+------------
 ����ԥ�`���ץ���ީ` | ��Z01��    | 
(1 row)

select * from Ӌ��C���Z where ����`�� like '_Z01_';
           ���Z           | ����`�� | �俼1a���� 
--------------------------+------------+------------
 ����ԥ�`���ץ���ީ` | ��Z01��    | 
(1 row)

select * from Ӌ��C���Z where ����`�� like '_Z%';
           ���Z           | ����`�� | �俼1a���� 
--------------------------+------------+------------
 ����ԥ�`���ץ���ީ` | ��Z01��    | 
(1 row)

select * from Ӌ��C���Z where ���Z ~ '����ԥ�`��[�ǥ�]';
            ���Z            | ����`�� | �俼1a���� 
----------------------------+------------+------------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    | 
 ����ԥ�`������ե��å��� | ��B10��    | 
(2 rows)

select * from Ӌ��C���Z where ���Z ~* '����ԥ�`��[�ǥ�]';
            ���Z            | ����`�� | �俼1a���� 
----------------------------+------------+------------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    | 
 ����ԥ�`������ե��å��� | ��B10��    | 
(2 rows)

select *,character_length(���Z) from Ӌ��C���Z;
            ���Z            | ����`�� | �俼1a���� | character_length 
----------------------------+------------+------------+------------------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    |            |               12
 ����ԥ�`������ե��å��� | ��B10��    |            |               13
 ����ԥ�`���ץ���ީ`   | ��Z01��    |            |               12
(3 rows)

select *,octet_length(���Z) from Ӌ��C���Z;
            ���Z            | ����`�� | �俼1a���� | octet_length 
----------------------------+------------+------------+--------------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    |            |           36
 ����ԥ�`������ե��å��� | ��B10��    |            |           39
 ����ԥ�`���ץ���ީ`   | ��Z01��    |            |           36
(3 rows)

select *,position('��' in ���Z) from Ӌ��C���Z;
            ���Z            | ����`�� | �俼1a���� | position 
----------------------------+------------+------------+----------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    |            |        7
 ����ԥ�`������ե��å��� | ��B10��    |            |        0
 ����ԥ�`���ץ���ީ`   | ��Z01��    |            |        0
(3 rows)

select *,substring(���Z from 10 for 4) from Ӌ��C���Z;
            ���Z            | ����`�� | �俼1a���� | substring 
----------------------------+------------+------------+-----------
 ����ԥ�`���ǥ����ץ쥤   | �CA01��    |            | �ץ쥤
 ����ԥ�`������ե��å��� | ��B10��    |            | ���å���
 ����ԥ�`���ץ���ީ`   | ��Z01��    |            | ��ީ`
(3 rows)