Filip RembiaÅkowski, 22.12.2010 14:28:
INSERT INTO tbl SELECT 1, '2010-01-01', '2010-12-31'; INSERT 0 1
I'm curious why you use this syntax as you have fixed values and could use the "standard" VALUES construct without problems: INSERT INTO tbl VALUES (1, '2010-01-01', '2010-12-31'); Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general