On Fri, Aug 13, 2021 at 07:09:15AM -0700, David G. Johnston wrote:
> On Fri, Aug 13, 2021 at 12:33 AM Gavin Flower <GavinFlower@archidevsys.co.nz>
> wrote:
>
>
> I always use the tz version, except when I forget.
>
>
> I find it nearly impossible for me to forget how this works. But that is
> probably because I just pretend that the standard, multi-word, data types don't
> even exist. It's not that "timestamp" defaults to "WITHOUT TIME ZONE" but
> rather that there are only two types in existence: timestamp and timestamptz.
> It's self-evident which one doesn't handle time zones.
>
>
>
> Suspect that it is extremely rare when one would not want to use the TZ
> option, which suggests to me that using TZ should be the default.
>
>
>
> I would agree, but at this point I'd leave it up to documentation and
> educational materials to teach/encourage, not runtime behaviors.
Yes, only using 'timetamptz' does fix it.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.