Postgres Pro
Downloads
Home   >   mailing lists

Re: generate_series for timestamptz and time zone problem - Mailing list pgsql-hackers

From Tom Lane
Subject Re: generate_series for timestamptz and time zone problem
Date
Msg-id 328603.1654030472@sss.pgh.pa.us
Whole thread Raw
In response to generate_series for timestamptz and time zone problem  (Przemysław Sztoch <przemyslaw@sztoch.pl>)
Responses Re: generate_series for timestamptz and time zone problem
List pgsql-hackers
Tree view 
=?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 by date:

Previous
From: Zhihong Yu
Date:
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Next
From: Robert Haas
Date:
Subject: Re: pg15b1: FailedAssertion("val > base", File: "...src/include/utils/relptr.h", Line: 67, PID: 30485)