Re: default localtimestamp at time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: default localtimestamp at time zone
Date: 2010-12-16 16:24:11
Message-ID: 22323.1292516651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Oddly, this doesn't work:
> create table test (x timestamp default localtimestamp at time zone 'UTC');
> ERROR: 42601: syntax error at or near "at"

> (Parentheses help.)

> The attached patch fixes it. Is there any reason for this omission?

I'm not really thrilled about adding low-usage options to b_expr. That
could back us into a corner later, by preventing b_expr from being used
in someplace where it'd be desirable.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-12-16 16:40:27 Re: Complier warnings on mingw gcc 4.5.0
Previous Message Andrew Chernow 2010-12-16 16:22:53 Re: [GENERAL] queriing the version of libpq