Re: Should we document how column DEFAULT expressions work? - Mailing list pgsql-hackers

From David Rowley
Subject Re: Should we document how column DEFAULT expressions work?
Date
Msg-id CAApHDvoirShaLmpwtqjnKfBUvWGoqSfcSSdEUK9nCkMWzujM+A@mail.gmail.com
Whole thread Raw
In response to Re: Should we document how column DEFAULT expressions work?  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
On Tue, 2 Jul 2024 at 13:48, David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Tue, 2 Jul 2024 at 02:43, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > I'd be more excited about this discussion if I didn't think that
> > the chances of removing 'now'::timestamp are exactly zero.  You
> > can't just delete useful decades-old features, whether there's
> > a better way or not.
>
> Do you have any thoughts on rejecting trailing punctuation with the
> timestamp special values?

Cancel that idea. I'd thought that these special values must be
standalone, but I didn't realise until a few minutes ago that it's
perfectly valid to mix them:

select 'yesterday 13:00:00'::timestamp, 'yesterday allballs'::timestamp;

David



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Should we document how column DEFAULT expressions work?
Next
From: Erik Wienhold
Date:
Subject: Re: CREATE OR REPLACE MATERIALIZED VIEW