Re: default localtimestamp at time zone - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default localtimestamp at time zone
Date
Msg-id 22323.1292516651@sss.pgh.pa.us
Whole thread Raw
In response to default localtimestamp at time zone  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.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


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: [GENERAL] queriing the version of libpq
Next
From: Andrew Dunstan
Date:
Subject: Re: Complier warnings on mingw gcc 4.5.0