Files
gnatcoll-db/pgxs/example/schema.sql
Vadim Godunko 21610444d2 SC06-078 Support of return of composite type.
Change-Id: I84d50d4d7db1cb38d85ae1962126e680c411100b
2020-05-18 19:41:55 +03:00

12 lines
299 B
SQL

CREATE TABLE emp
(name CHARACTER VARYING NOT NULL UNIQUE,
salary INTEGER);
INSERT INTO emp VALUES ('Bill', 900);
INSERT INTO emp VALUES ('Bob', 90);
INSERT INTO emp VALUES ('Sam', 9);
INSERT INTO emp VALUES ('Null', null);
CREATE TYPE apgxs_composite_type AS (x integer, y integer);