On 2009-07-18, Gianvito Pio <pio.gianv...@gmail.com> wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_0017_01CA0791.49E30EB0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi all, > how can I define a column of timestamp with timezone type...with a = > default value?
Same as any other column with a default value. If you're inserting NULL into the column the NULL will override the default. Postgres does what you tell it. If you want the default value use the keyword DEFAULT (in for the value in that column) or don't mention that column. The DEFAULT keyword also works with UPDATE. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
