| 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) |
| |
