| drop table vZ@pê; |
| create table vZ@pê (pê text, ªÞR[h varchar, õl1A¾æ char(16)); |
| create index vZ@pêindex1 on vZ@pê using btree (pê); |
| create index vZ@pêindex2 on vZ@pê using hash (ªÞR[h); |
| insert into vZ@pê values('Rs
[^fBXvC','@A01ã'); |
| insert into vZ@pê values('Rs
[^OtBbNX','ªB10'); |
| insert into vZ@pê values('Rs
[^vO}[','lZ01º'); |
| vacuum vZ@pê; |
| select * from vZ@pê; |
| pê | ªÞR[h | õl1a¾æ |
| ----------------------------+------------+------------ |
| Rs
[^fBXvC | @A01ã | |
| Rs
[^OtBbNX | ªB10 | |
| Rs
[^vO}[ | lZ01º | |
| (3 rows) |
| |
| select * from vZ@pê where ªÞR[h = 'lZ01º'; |
| pê | ªÞR[h | õl1a¾æ |
| --------------------------+------------+------------ |
| Rs
[^vO}[ | lZ01º | |
| (1 row) |
| |
| select * from vZ@pê where ªÞR[h ~* 'lz01º'; |
| pê | ªÞR[h | õl1a¾æ |
| --------------------------+------------+------------ |
| Rs
[^vO}[ | lZ01º | |
| (1 row) |
| |
| select * from vZ@pê where ªÞR[h like '_Z01_'; |
| pê | ªÞR[h | õl1a¾æ |
| --------------------------+------------+------------ |
| Rs
[^vO}[ | lZ01º | |
| (1 row) |
| |
| select * from vZ@pê where ªÞR[h like '_Z%'; |
| pê | ªÞR[h | õl1a¾æ |
| --------------------------+------------+------------ |
| Rs
[^vO}[ | lZ01º | |
| (1 row) |
| |
| select * from vZ@pê where pê ~ 'Rs
[^[fO]'; |
| pê | ªÞR[h | õl1a¾æ |
| ----------------------------+------------+------------ |
| Rs
[^fBXvC | @A01ã | |
| Rs
[^OtBbNX | ªB10 | |
| (2 rows) |
| |
| select * from vZ@pê where pê ~* 'Rs
[^[fO]'; |
| pê | ªÞR[h | õl1a¾æ |
| ----------------------------+------------+------------ |
| Rs
[^fBXvC | @A01ã | |
| Rs
[^OtBbNX | ªB10 | |
| (2 rows) |
| |
| select *,character_length(pê) from vZ@pê; |
| pê | ªÞR[h | õl1a¾æ | character_length |
| ----------------------------+------------+------------+------------------ |
| Rs
[^fBXvC | @A01ã | | 12 |
| Rs
[^OtBbNX | ªB10 | | 13 |
| Rs
[^vO}[ | lZ01º | | 12 |
| (3 rows) |
| |
| select *,octet_length(pê) from vZ@pê; |
| pê | ªÞR[h | õl1a¾æ | octet_length |
| ----------------------------+------------+------------+-------------- |
| Rs
[^fBXvC | @A01ã | | 24 |
| Rs
[^OtBbNX | ªB10 | | 26 |
| Rs
[^vO}[ | lZ01º | | 24 |
| (3 rows) |
| |
| select *,position('f' in pê) from vZ@pê; |
| pê | ªÞR[h | õl1a¾æ | position |
| ----------------------------+------------+------------+---------- |
| Rs
[^fBXvC | @A01ã | | 7 |
| Rs
[^OtBbNX | ªB10 | | 0 |
| Rs
[^vO}[ | lZ01º | | 0 |
| (3 rows) |
| |
| select *,substring(pê from 10 for 4) from vZ@pê; |
| pê | ªÞR[h | õl1a¾æ | substring |
| ----------------------------+------------+------------+----------- |
| Rs
[^fBXvC | @A01ã | | vC |
| Rs
[^OtBbNX | ªB10 | | BbNX |
| Rs
[^vO}[ | lZ01º | | }[ |
| (3 rows) |
| |
| copy vZ@pê to stdout; |
| Rs
[^fBXvC @A01ã \N |
| Rs
[^OtBbNX ªB10 \N |
| Rs
[^vO}[ lZ01º \N |