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 1sO7A6-00CQOZ-8n
	for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 02:53:02 +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 1sO7A4-00EZUe-My
	for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 02:53:01 +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 1sO7A4-00EZUV-DQ
	for pgsql-hackers@lists.postgresql.org; Mon, 01 Jul 2024 02:53:00 +0000
Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131])
	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 1sO7A2-003xQa-At
	for pgsql-hackers@postgresql.org; Mon, 01 Jul 2024 02:52:59 +0000
Received: by mail-lf1-x131.google.com with SMTP id 2adb3069b0e04-52ce6c8db7bso3652686e87.1
        for <pgsql-hackers@postgresql.org>; Sun, 30 Jun 2024 19:52:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1719802377; x=1720407177; 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=7IRToxAjj6s7FDqpNzwomfKsjw7NIlGaPCZaTc7CSrw=;
        b=HnmpZWbNUHIWYpvsAKuF1GjJzX4iDQRySIsITmIRjWEiuhtHwHEX1ic6tJzpUBcvYD
         EbyNRYQ7DhU812MbpijI+YJV4iozZBaOKqbxjzmFclfpCcPzTu7b8UefvJ4GKLvmeWVv
         uEjRPf2NIXDPXCabSsC/nGpyGBPKyv+1QbSB8JDM6uC5NKSJXQnj0H9eRjQkS6p+FtIY
         qs5/6Ci9ncxkMH+lKA1BZ1N0X5/qhQvxW25I+0Duk4aXZJOpHbSGujr57bC9qbk2XFny
         XxZYsx7AANyveU/UPkbLb6IQdZrTBR8SVnqM6gWcifEH1fQNCAXFsvLnVVnk0EuBsnTb
         dtvA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1719802377; x=1720407177;
        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=7IRToxAjj6s7FDqpNzwomfKsjw7NIlGaPCZaTc7CSrw=;
        b=MKXoiDwldtZnvDQj5dJ+E8473Qso2I7KXsnKm8ErCUJxQj1X9FfQlDz/qng75NZ9/0
         YVK55qvW1Vw/S0kdM/jg5C7Wj69xIK+HbogKPLtVIQ1bHyF8q00hievp9HkQWCkxmyjN
         943vvazixxK4HLnQ+I+u8mkTAM8wvyNjqaPg1RhcAwAVkIvDaPKr5zCtdPxWIBp7NC9G
         RFEk8ro4fD15HEAtd8VkmOiFTYGSSho16zdJy9f5vfnxxYDG6fVNi0DNfRC7hI0En1PC
         meC/Y/BQNifjsvStdhkvCl5bMQ3xJJw79txeGYAODYYamc9h7Q9wIqEWOIgyUV4NYbhT
         AX7w==
X-Forwarded-Encrypted: i=1; AJvYcCX1OqavE5dcxI7FYzNXmVfK154nQ7MYQ/ewuB34cUcem5H69szssdLREK/WgsJYDfmuBJilYbPKBAZhJqE6SOSC/+EqPngMQoL9t7Sq
X-Gm-Message-State: AOJu0YxrG6nd3xT3W3W2CWJ1ktEvNRiMMCfrwNosh8rk6e8bdWlLZugG
	SbXMr1mcF/N4quEkPIwjaqe5VHZXP5E5zNetg7tva+U1LjtmGB1XXf/RZcPsM3l/XrzATVeiPSZ
	RW+wONBI7C+qEZDsauJCvZaxDT2A=
X-Google-Smtp-Source: AGHT+IFflYz/hsRLOlE2hZ+xe31JwB7J/Vzcdt23KB0nsQZ1qcaUOELMI/KeI1WX+MVCFMMpeU0lY5jC91z+0LCk4JY=
X-Received: by 2002:a05:6512:1251:b0:52c:deba:7e6e with SMTP id
 2adb3069b0e04-52e82691371mr3574671e87.29.1719802376370; Sun, 30 Jun 2024
 19:52: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>
 <CAKFQuwbOOQ20=Pb5j-k+Sws22H5W9tnj-vve4MC-GQ9RmmtTxA@mail.gmail.com>
 <CAApHDvogKE8RrHx=qmYfvpD_AiVLX14nLvvSrPbFCXWgiYrKxg@mail.gmail.com> <CAKFQuwZjuQX4H48MbaHZAX3s__LoHgkXsf2Eg--E=qtWFss0bg@mail.gmail.com>
In-Reply-To: <CAKFQuwZjuQX4H48MbaHZAX3s__LoHgkXsf2Eg--E=qtWFss0bg@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Mon, 1 Jul 2024 14:52:42 +1200
Message-ID: <CAApHDvrQ--Mzp00Yn=3SVB=YS_ZB15aeLywaK0n05-adk8WWmw@mail.gmail.com>
Subject: Re: Should we document how column DEFAULT expressions work?
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>, Tom Lane <tgl@sss.pgh.pa.us>, 
	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/CAApHDvrQ--Mzp00Yn%3D3SVB%3DYS_ZB15aeLywaK0n05-adk8WWmw%40mail.gmail.com>
Precedence: bulk

On Mon, 1 Jul 2024 at 13:41, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> I presume the relatively new atomic SQL functions pose a similar hazard.

Do you have an example of this?

> The fact that 'now()'::timestamp fails to fail doesn't help...

If that's the case, maybe a tiny step towards what Peter proposed is
just to make trailing punctuation fail for timestamp special values in
v18.

David