sjis.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

drop table 寁嶼婡梡岅;
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)

copy 寁嶼婡梡岅 to stdout;
僐儞僺儏乕僞僨傿僗僾儗僀	婡A01忋	\N
僐儞僺儏乕僞僌儔僼傿僢僋僗	暘B10拞	\N
僐儞僺儏乕僞僾儘僌儔儅乕	恖Z01壓	\N