Re: Should we document how column DEFAULT expressions work?

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Should we document how column DEFAULT expressions work?
Дата
Msg-id CAApHDvomTw5i0F3TdvPvjG+4FUiS2pXV1PrVV+mrCOOZM8R4Ww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Should we document how column DEFAULT expressions work?  (James Coleman <jtc331@gmail.com>)
Список pgsql-hackers
On Wed, 26 Jun 2024 at 11:05, James Coleman <jtc331@gmail.com> wrote:
> Hmm, I guess I'd never considered anything besides cases like
> nextval() and now(), but I see now that now() must also be special
> cased (when quoted) since 'date_trunc(day, now())'::timestamp doesn't
> work but 'now()'::timestamp does.

'now()'::timestamp only works because we ignore trailing punctuation
in ParseDateTime() during timestamp_in(). 'now!!'::timestamp works
equally as well.

David



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: TruncateMultiXact() bugs
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Should we document how column DEFAULT expressions work?