euc_jp.sql

来自「关系型数据库 Postgresql 6.5.2」· SQL 代码 · 共 20 行

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 纷换怠脱胳;
select * from 纷换怠脱胳 where 尸梧コ〖ド = '客Z01布';
select * from 纷换怠脱胳 where 尸梧コ〖ド ~* '客z01布';
select * from 纷换怠脱胳 where 尸梧コ〖ド like '_Z01_';
select * from 纷换怠脱胳 where 尸梧コ〖ド like '_Z%';
select * from 纷换怠脱胳 where 脱胳 ~ 'コンピュ〖タ[デグ]';
select * from 纷换怠脱胳 where 脱胳 ~* 'コンピュ〖タ[デグ]';
select *,character_length(脱胳) from 纷换怠脱胳;
select *,octet_length(脱胳) from 纷换怠脱胳;
select *,position('デ' in 脱胳) from 纷换怠脱胳;
select *,substring(脱胳 from 10 for 4) from 纷换怠脱胳;