Re: Possible bug in date(timestamptz)?

Поиск
Список
Период
Сортировка
Искать
От
dev@archonet.com
Тема
Re: Possible bug in date(timestamptz)?
Дата
Msg-id
49178.192.168.1.32.1048801128.squirrel@mainbox.archonet.com
Ответ на
Список
Дерево обсуждения
Possible bug in date(timestamptz)? Richard Huxton <dev@archonet.com>
Re: Possible bug in date(timestamptz)? Tom Lane <tgl@sss.pgh.pa.us>
Re: Possible bug in date(timestamptz)? dev@archonet.com
> Richard Huxton  writes:
>> I can't think why one would be immutable and the other not,
>
> You aren't thinking hard enough, then :-(
>
> date(timestamptz) depends on the TimeZone setting, the other does not.

I thought immutable was for the length of a statement. Reading it, I see
that "stable" covers that. Timestamp without time zone it is then.

Thanks Tom

- Richard Huxton

В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Haroldo Stenger
Дата:
FAQ