Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sPrez-006i4B-4s
	for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jul 2024 22:44:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sPrev-00F0O7-JL
	for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jul 2024 22:44:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1sPrev-00F0M3-9W
	for pgsql-hackers@lists.postgresql.org; Fri, 05 Jul 2024 22:44:05 +0000
Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1sPrep-000bUz-BE
	for pgsql-hackers@postgresql.org; Fri, 05 Jul 2024 22:44:04 +0000
Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-2ee88c4443eso23803831fa.3
        for <pgsql-hackers@postgresql.org>; Fri, 05 Jul 2024 15:43:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1720219437; x=1720824237; darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=y9F15YEYAyyKdZIXxmMbd/ScCTjvykBzduYzmho/qic=;
        b=jWUc2aUBIkY2yiGBr5bfZMPClVFj6x4sy3dFE2Qw/b9T4a6ZxFRH/4r/lPSlcp96Qq
         TgPfgoCNHobWv1S8bWJimTcdudqFG6Xs6kotMdbKfhD9iuTjxZY0UCVmIBW7Eoh6OmZz
         59s5NN4vEgEK0KZ78V3UKLx24Ago2QtBKHiOVHJcMPvzneR2OKtWzPf5aoq0LZ0lnMe1
         zkL8c0+3KRDT0EUj3KlI1ZjURxBkb8BMcl4dLXLIdUxRE5xzb2TSgv8jUkMOlJ60cOKs
         sLsI1AC5B7FWuzXy/epLyBtsOp0YPe8OB+CltesbQLnoVvLfiRdYM9CePqmcEXUgtKgC
         Fgdg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1720219437; x=1720824237;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=y9F15YEYAyyKdZIXxmMbd/ScCTjvykBzduYzmho/qic=;
        b=wq5jHyKaWkymXJuK30qft8J4+qU9Bch9AMpD6yDU4HXDEo5PC8k7V+7QiAYNmLnnHa
         7D7AvtubDGhMJ8mIERYc9DFA48v4GoGcWM1vMalC3lPDE/0RqIJkb5HU++pL+YqtzlNC
         WyO6kNkviMYEGED5zVv4pF6vGnc0sAaRQiHzyGu9lr80DLnhPtji+uMd8ycu2gWZjWOm
         VKOiPgwCiH+GvOXZ1E7w+hpZhkVgaVevv9Kc6i/2fr1NrQM4CHofl+1UFudxOM3g+U8b
         vTDR0DI1kYB2dc8bkbc/9c20IQuduKWHiPjXwfqQgehn+8BQbi5ZyJBTfCHsrKQmPGHx
         eyaw==
X-Forwarded-Encrypted: i=1; AJvYcCX7aEuvw+dMk9rTYig9HPUwGa7Ty5ttzty49OBGDTNJf8d53vwApb00SW83MLTPj5JXIurenEmDFQb6YrxAXNT05kKkX1iiw/a6ltq3
X-Gm-Message-State: AOJu0YwBtmsj+RnKWFPJKCka7bJ6dVhsrKZc/BFcDDTNKK9Caav+FDnx
	McauXBiEh9z6u1wR3regbBNz4gOeXWXeEWP081OibFBoHc1O/jBbPIbZVaa0rcO9M1bPU1DEbQA
	ZrETdPqdmzyjKR2qHvC8KbSy9psg=
X-Google-Smtp-Source: AGHT+IGokIEXDCQ5Hl65JRLifLP32DXfUctIxEYetSieSXs62OQuXx/rS9jtFFsAzKIhNfTDt1NtWvIrytNzKPoTy6c=
X-Received: by 2002:a05:651c:1a27:b0:2ee:8aed:ddba with SMTP id
 38308e7fff4ca-2ee8ed69fc4mr54639171fa.4.1720219436954; Fri, 05 Jul 2024
 15:43:56 -0700 (PDT)
MIME-Version: 1.0
References: <CAAaqYe-wQPbchCUE7pocPNEQ3PMY8a98Txmxc7q0+FvXtk1vvg@mail.gmail.com>
 <1362410.1719349169@sss.pgh.pa.us> <CAAaqYe9_RE2WximHuYRpyfU-H2G+W--49e_8GDqS-vHLOzPvmg@mail.gmail.com>
 <1390099.1719357084@sss.pgh.pa.us> <CAKFQuwZkgm0yqHhf05thqu1gzUK__gXBL5tyBuFvKoOe7Dd6=A@mail.gmail.com>
 <CAApHDvoiHYxM2VQYZeiF7JAdP7Y0JxEr86NZpUjoZ9AA4cpzYw@mail.gmail.com>
 <CAKFQuwbyjn0p5aKz1sKfJHQCTbGy1xhWaNR2xdnXv-X4oPdOGA@mail.gmail.com>
 <CAApHDvqShXhOat03iEV1VqXM68DBJ+zM95Ghbu0rcqs8KnhQQQ@mail.gmail.com>
 <1642803.1719447063@sss.pgh.pa.us> <CAApHDvouPRyga3-5ZYLt_RUhU942bk0WPVgro+U=R3cvBRXbeQ@mail.gmail.com>
 <ef4d9b38-b7a5-4c85-ba12-062929c2d136@eisentraut.org> <CAApHDvrURTcDn3GTsmXzm9VqT3acLh=T=aUYMuKrtozw0nq8Tg@mail.gmail.com>
 <bff385a9-adba-4516-8164-a1239f2f002a@eisentraut.org> <2739273.1719845033@sss.pgh.pa.us>
 <CAApHDvqxraGnZGy2Aa+r2X7-BgrdkcmUFs=9UOfQoR2B+i2WaA@mail.gmail.com>
In-Reply-To: <CAApHDvqxraGnZGy2Aa+r2X7-BgrdkcmUFs=9UOfQoR2B+i2WaA@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Sat, 6 Jul 2024 10:43:44 +1200
Message-ID: <CAApHDvoirShaLmpwtqjnKfBUvWGoqSfcSSdEUK9nCkMWzujM+A@mail.gmail.com>
Subject: Re: Should we document how column DEFAULT expressions work?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter@eisentraut.org>, "David G. Johnston" <david.g.johnston@gmail.com>, 
	James Coleman <jtc331@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/CAApHDvoirShaLmpwtqjnKfBUvWGoqSfcSSdEUK9nCkMWzujM%2BA%40mail.gmail.com>
Precedence: bulk

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