Re: default localtimestamp at time zone
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-16T16:24:11Z
Lists: 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