| drop table ¼t°Ó¸ê®Æ; |
| create table ¼t°Ó¸ê®Æ (¦æ·~§O text, ¤½¥q©ïÀY varchar, ¦a§} varchar(16)); |
| create index ¼t°Ó¸ê®Æindex1 on ¼t°Ó¸ê®Æ using btree (¦æ·~§O); |
| create index ¼t°Ó¸ê®Æindex2 on ¼t°Ó¸ê®Æ using hash (¤½¥q©ïÀY); |
| insert into ¼t°Ó¸ê®Æ values ('¹q¸£·~', '¹F¹F¬ì§Þ', '¥_A01¤¯'); |
| insert into ¼t°Ó¸ê®Æ values ('»s³y·~', '°]·½¦³¤½¥q', '¤¤B10¤¤'); |
| insert into ¼t°Ó¸ê®Æ values ('À\¶¼·~', '¬ü¨ýªÑ¥÷¦³¤½¥q', '°ªZ01¤E'); |
| vacuum ¼t°Ó¸ê®Æ; |
| select * from ¼t°Ó¸ê®Æ; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+------------------+--------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ |
| »s³y·~ | °]·½¦³¤½¥q | ¤¤B10¤¤ |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E |
| (3 rows) |
| |
| select * from ¼t°Ó¸ê®Æ where ¦a§} = '°ªZ01¤E'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+------------------+--------- |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E |
| (1 row) |
| |
| select * from ¼t°Ó¸ê®Æ where ¦a§} ~* '°ªz01¤E'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+------------------+--------- |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E |
| (1 row) |
| |
| select * from ¼t°Ó¸ê®Æ where ¦a§} like '_Z01_'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+------------------+--------- |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E |
| (1 row) |
| |
| select * from ¼t°Ó¸ê®Æ where ¦a§} like '_Z%'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+------------------+--------- |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E |
| (1 row) |
| |
| select * from ¼t°Ó¸ê®Æ where ¤½¥q©ïÀY ~ '¹F¹F¬ì[±H°O§Þ]'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+----------+--------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ |
| (1 row) |
| |
| select * from ¼t°Ó¸ê®Æ where ¤½¥q©ïÀY ~* '¹F¹F¬ì[±H°O§Þ]'; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} |
| --------+----------+--------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ |
| (1 row) |
| |
| select *, character_length(¦æ·~§O) from ¼t°Ó¸ê®Æ; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | character_length |
| --------+------------------+---------+------------------ |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | 3 |
| »s³y·~ | °]·½¦³¤½¥q | ¤¤B10¤¤ | 3 |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E | 3 |
| (3 rows) |
| |
| select *, octet_length(¦æ·~§O) from ¼t°Ó¸ê®Æ; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | octet_length |
| --------+------------------+---------+-------------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | 6 |
| »s³y·~ | °]·½¦³¤½¥q | ¤¤B10¤¤ | 6 |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E | 6 |
| (3 rows) |
| |
| select *, position('¦³' in ¤½¥q©ïÀY) from ¼t°Ó¸ê®Æ; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | position |
| --------+------------------+---------+---------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | 0 |
| »s³y·~ | °]·½¦³¤½¥q | ¤¤B10¤¤ | 3 |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E | 5 |
| (3 rows) |
| |
| select *, substring(¤½¥q©ïÀY from 3 for 6 ) from ¼t°Ó¸ê®Æ; |
| ¦æ·~§O | ¤½¥q©ïÀY | ¦a§} | substring |
| --------+------------------+---------+-------------- |
| ¹q¸£·~ | ¹F¹F¬ì§Þ | ¥_A01¤¯ | ¬ì§Þ |
| »s³y·~ | °]·½¦³¤½¥q | ¤¤B10¤¤ | ¦³¤½¥q |
| À\¶¼·~ | ¬ü¨ýªÑ¥÷¦³¤½¥q | °ªZ01¤E | ªÑ¥÷¦³¤½¥q |
| (3 rows) |
| |