Re: Question about inscrutable cast syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question about inscrutable cast syntax
Дата
Msg-id 26962.1229705613@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question about inscrutable cast syntax  (Kevin Murphy <murphy@genome.chop.edu>)
Список pgsql-general
Kevin Murphy <murphy@genome.chop.edu> writes:
> lastupdated timestamp without time zone DEFAULT
> ('now'::text)::timestamp(6) with time zone NOT NULL

> For my personal edification, I'd like to understand what's going on with
> that first one!

It's what the PG grammar converts CURRENT_TIMESTAMP(6) into.

(We really ought to do a better job of hiding that from the user...)

            regards, tom lane

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

Предыдущее
От: Kevin Murphy
Дата:
Сообщение: Question about inscrutable cast syntax
Следующее
От: Jason Long
Дата:
Сообщение: Out of control query