Re: generate_series for timestamptz and time zone problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: generate_series for timestamptz and time zone problem
Дата
Msg-id 328603.1654030472@sss.pgh.pa.us
обсуждение исходный текст
Ответ на generate_series for timestamptz and time zone problem  (Przemysław Sztoch <przemyslaw@sztoch.pl>)
Ответы Re: generate_series for timestamptz and time zone problem
Список pgsql-hackers
=?UTF-8?Q?Przemys=c5=82aw_Sztoch?= <przemyslaw@sztoch.pl> writes:
> |generate_series| ( /|start|/ |timestamp with time zone|, /|stop|/ 
> |timestamp with time zone|, /|step|/ |interval| )
> produces results depending on the timezone value set:

That's intentional.  If you don't want it, maybe you should be using
generate_series on timestamp without time zone?

            regards, tom lane



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