Обсуждение: default localtimestamp at time zone

Поиск
Список
Период
Сортировка

default localtimestamp at time zone

От
Peter Eisentraut
Дата:
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?

(The patch also works in past releases, so it was not obviously a parser
problem.)

Вложения

Re: default localtimestamp at time zone

От
Tom Lane
Дата:
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