Re: is date_part immutable or not?

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: is date_part immutable or not?
Date: 2020-08-21 13:36:57
Message-ID: D3AF9A96-8C7A-4C87-8260-78CEF389783D@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 21 авг. 2020 г., в 16:14, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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 the daylight 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Boussekey 2020-08-21 13:46:21 Fwd: When are largobject records TOASTed into pg_toast_2613?
Previous Message Laurenz Albe 2020-08-21 13:14:41 Re: is date_part immutable or not?