Re: [SQL] Timestamp with timezone with Default value

2009-07-19 Thread Jasen Betts
On 2009-07-18, Gianvito Pio 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 timezon

Re: [SQL] Timestamp with timezone with Default value

2009-07-18 Thread Jasmin Dizdarevic
Hi, i think: create. ...( myCol timestamp with timezone default now() ) the function now() returns a timestamp with timezone ( http://www.postgresql.org/docs/8.4/static/functions-datetime.html) i currently have no db to test it - but it should work. jasmin 2009/7/18 Gianvito Pio > Hi all,