select.sql.out

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

QUERY: select 1 as X;
X  
-- 
1  
QUERY: create table foo (name char16, salary int4);
QUERY: insert into foo values ('mike', 15000);
QUERY: select * from foo where 2 > 1;
name  salary  
----- ------- 
mike  15000   
QUERY: select * from pg_class where 1=0;
relname  reltype  relowner  relam  relpages  reltuples  relexpires  relpreserved  relhasindex  relisshared  relkind  relarch  relnatts  relsmgr  relkey  relkeyop  relhasrules  relacl  
-------- -------- --------- ------ --------- ---------- ----------- ------------- ------------ ------------ -------- -------- --------- -------- ------- --------- ------------ ------- 
QUERY: create table bar (x int4);
QUERY: insert into bar values (1);
QUERY: insert into bar values (2);
QUERY: insert into bar values (1);
QUERY: select distinct * from bar;
x  
-- 
1  
2  
QUERY: select distinct * into table bar2 from bar;
QUERY: select distinct * from bar2;
x  
-- 
1  
2  
QUERY: drop table foo;
QUERY: drop table bar;
QUERY: drop table bar2;