Re: is date_part immutable or not? - Mailing list pgsql-general

From Олег Самойлов
Subject Re: is date_part immutable or not?
Date
Msg-id D3AF9A96-8C7A-4C87-8260-78CEF389783D@ya.ru
Whole thread Raw
In response to Re: is date_part immutable or not?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
> 21 авг. 2020 г., в 16:14, Laurenz Albe <laurenz.albe@cybertec.at> написал(а):
> Two approaches:
>
> 1. Use "timestamp without time zone".

Yep, I redefined to timestamp without time zone. Thus loose timezone information from source, but happily there is not
thedaylight savings time shift in my country now. 

>
> 2. Partition in some other way, for example BY RANGE (log_time).
>   Your list partitions don't make a lot of sense to me.

This copies default name structure of the postgresql log files.


pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: is date_part immutable or not?
Next
From: Thomas Boussekey
Date:
Subject: Fwd: When are largobject records TOASTed into pg_toast_2613?