What is the behavior if a column data type is timestamptz but there is only the date portion available? There must be a default time; can that be defined? Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general