Re: Default to TIMESTAMP WITH TIME ZONE?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Default to TIMESTAMP WITH TIME ZONE?
Date: 2021-08-13 18:47:45
Message-ID: CAKFQuwa2--Ssqx0yhjOztX3F4yUOVHPtL54m1aYthGzJJopsWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday, August 13, 2021, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> The one thing I could potentially see us doing is more strongly
> encouraging the use of the names "timestamp" and "timestamptz",
> up to and including changing what format_type() et al. put out.

+1. Having the canonical form be timestamptz would make pretending the
“with time zone” version doesn’t exist much easier.

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2021-08-13 18:50:16 Re: Autovacuum on partitioned table (autoanalyze)
Previous Message Tom Lane 2021-08-13 18:09:04 Re: [PATCH] Native spinlock support on RISC-V