Kevin Murphy <murphy@xxxxxxxxxxxxxxx> writes: > lastupdated timestamp without time zone DEFAULT > ('now'::text)::timestamp(6) with time zone NOT NULL > For my personal edification, I'd like to understand what's going on with > that first one! It's what the PG grammar converts CURRENT_TIMESTAMP(6) into. (We really ought to do a better job of hiding that from the user...) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general