Re: mark the timestamptz variant of date_bin() as stable

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: mark the timestamptz variant of date_bin() as stable
Дата
Msg-id CAFBsxsH1OrS+=iKNWBiO4W4mfh6=ug8myrb6XwPXEWSJS8S6WA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: mark the timestamptz variant of date_bin() as stable  (Aleksander Alekseev <aleksander@timescale.com>)
Ответы Re: mark the timestamptz variant of date_bin() as stable  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

On Wed, Sep 1, 2021 at 5:32 AM Aleksander Alekseev <aleksander@timescale.com> wrote:
>
> By looking at timestamptz_bin() implementation I don't see why it
> should be STABLE. Its return value depends only on the input values.
> It doesn't look at the session parameters. timestamptz_in() and
> timestamptz_out() are STABLE, that's true, but this is no concern of
> timestamptz_bin().

I'm not quite willing to bet the answer couldn't change if the timezone changes, but it's possible I'm the one missing something.

--
John Naylor
EDB: http://www.enterprisedb.com

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: prevent immature WAL streaming
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Converting contrib SQL functions to new style