INSERT INTO tmp VALUES (5, '!check failed', null);

INSERT INTO tmp VALUES (null, 'try again', null);

INSERT INTO INSERT_TBL(y) select yd from tmp;

NOTICE: insert_seq.nextval: sequence was re-created

WARNING: insert_seq.nextval: sequence was re-created

SELECT '' AS three, * FROM INSERT_TBL;

three | x | y | z

-------+---+---------------+----

-- Primary keys

--

CREATE TABLE PRIMARY_TBL (i int PRIMARY KEY, t text);

INFO: CREATE TABLE / PRIMARY KEY will create implicit index 'primary_tbl_pkey' for table 'primary_tbl'

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'primary_tbl_pkey' for table 'primary_tbl'

INSERT INTO PRIMARY_TBL VALUES (1, 'one');

INSERT INTO PRIMARY_TBL VALUES (2, 'two');

INSERT INTO PRIMARY_TBL VALUES (1, 'three');

DROP TABLE PRIMARY_TBL;

CREATE TABLE PRIMARY_TBL (i int, t text,

PRIMARY KEY(i,t));

INFO: CREATE TABLE / PRIMARY KEY will create implicit index 'primary_tbl_pkey' for table 'primary_tbl'

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'primary_tbl_pkey' for table 'primary_tbl'

INSERT INTO PRIMARY_TBL VALUES (1, 'one');

INSERT INTO PRIMARY_TBL VALUES (2, 'two');

INSERT INTO PRIMARY_TBL VALUES (1, 'three');

-- Unique keys

--

CREATE TABLE UNIQUE_TBL (i int UNIQUE, t text);

INFO: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key' for table 'unique_tbl'

NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key' for table 'unique_tbl'

INSERT INTO UNIQUE_TBL VALUES (1, 'one');

INSERT INTO UNIQUE_TBL VALUES (2, 'two');

INSERT INTO UNIQUE_TBL VALUES (1, 'three');

DROP TABLE UNIQUE_TBL;

CREATE TABLE UNIQUE_TBL (i int, t text,

UNIQUE(i,t));

INFO: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key' for table 'unique_tbl'

NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_tbl_i_key' for table 'unique_tbl'

INSERT INTO UNIQUE_TBL VALUES (1, 'one');

INSERT INTO UNIQUE_TBL VALUES (2, 'two');

INSERT INTO UNIQUE_TBL VALUES (1, 'three');

RETURNS widget

AS '@abs_builddir@/regress@DLSUFFIX@'

LANGUAGE 'c';

NOTICE: ProcedureCreate: type widget is not yet defined

WARNING: ProcedureCreate: type widget is not yet defined

CREATE FUNCTION widget_out(opaque)

RETURNS opaque

AS '@abs_builddir@/regress@DLSUFFIX@'

RETURNS hobbies_r.person%TYPE

AS 'select person from hobbies_r where name = $1'

LANGUAGE 'sql';

INFO: hobbies_r.name%TYPE converted to text

INFO: hobbies_r.person%TYPE converted to text

NOTICE: hobbies_r.name%TYPE converted to text

NOTICE: hobbies_r.person%TYPE converted to text

CREATE FUNCTION equipment(hobbies_r)

RETURNS setof equipment_r

AS 'select * from equipment_r where hobby = $1.name'