Ticket #15586: test.sql

File test.sql, 270 bytes (added by Łukasz Rekucki, 14 years ago)

SQL query to check against.

Line 
1CREATE TABLE test (id INTEGER PRIMARY KEY);
2INSERT INTO test VALUES (1), (2), (3);
3SELECT "test"."id", "test"."name" FROM "test";
4DROP TABLE test;
5
6--
7-- Result should look like this:
8
9-- id | name
10-- ----+------
11-- 1 | (1)
12-- 2 | (2)
13-- 3 | (3)
14-- (3 rows)
15--
Back to Top