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