blob: ba4c75de9846c06857b1457a271608940fc69d6d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
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;
|
