On Wed, 29 Feb 2012, Andrew Gould wrote:
If the column is null'able, I think you can use the keyword: DEFAULT insert into(id, xdate) values (1, DEFAULT);
Or... use NULL: insert into(id, xdate) values (1, NULL);
NULL works, but one advantage of using DEFAULT is that you won't have to worry which columns are set to NOT NULL. This assumes that the NOT NULL columns have default values assigned to them, which is a good idea.
Thank you both. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
