diff options
Diffstat (limited to 'project2/sql/unittests/pqschema.sql')
| -rw-r--r-- | project2/sql/unittests/pqschema.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/project2/sql/unittests/pqschema.sql b/project2/sql/unittests/pqschema.sql index 506365b..21277ca 100644 --- a/project2/sql/unittests/pqschema.sql +++ b/project2/sql/unittests/pqschema.sql @@ -2,10 +2,12 @@ -- pg_dump style comment -- Table: test; owner: comment: ; -- + /* This is a multiline comment */ + CREATE TABLE test( id int, fl numeric(5,2), @@ -13,4 +15,14 @@ CREATE TABLE test( boolean bool, dt timestamp without time zone, ts interval); + INSERT INTO test VALUES(4, 123.45, 'some text with a ; in it and a '' too', true, '2015-04-27 23:06:03', '1 day 14:13:12'); + +CREATE FUNCTION event_tsvector() RETURNS int +LANGUAGE sql STABLE +AS $tag$ + SELECT max(id) + FROM test + WHERE string != 'complex '' string;'; +$tag$; + |