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 ) id 1sO7W1-00CSkJ-HT for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 03:15:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sO7Vz-00EjcQ-SS for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 03:15:40 +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 ) id 1sO7Vz-00EjcI-Ir for pgsql-hackers@lists.postgresql.org; Mon, 01 Jul 2024 03:15:39 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sO7Vx-003xZM-4k for pgsql-hackers@postgresql.org; Mon, 01 Jul 2024 03:15:38 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-24c9f630e51so1334353fac.1 for ; Sun, 30 Jun 2024 20:15:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719803736; x=1720408536; 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=B1rx9jNOy/92erA9UKUtl2qIZ0tZl4oJHC/QiiHzzkg=; b=iqF3FNYIKubTVeUpxW19cosqhA/lPHaSoQMUgVHV9QNBYsuvtFu+xUXbKWUReh9R1c 16P/AZlIGSg1OxwtH3d5o+IZtrzx928qVLMZq+CB4qnYVDHRfQuOtbVyCXMzK1gZbzYN kzG/ga3T9ERdGIj0xGxmwji5CYuBZ0pNqDaOIwkXbJrlE1Lr0aPSLz78Xd8qTsjLqw2l s645wNk+XFrsdIddS5yZFYEbAO3+goFOuNZvC4diPeln0lriMof2KwxmC9bolTwcAUA1 VytGEwuY+MtpMqF0QqYlZ7KyV1Wkc3A6eIpi9vTtWmw0B4lih4UzXoI7sNf5sWk2cgyE pwCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719803736; x=1720408536; 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=B1rx9jNOy/92erA9UKUtl2qIZ0tZl4oJHC/QiiHzzkg=; b=w/0NzFDLEsM63ZQIIJNzbhoqBgcJdzGc4zwbCF1Iy0LZomF6X0S+iZmOZ6pSHaJhPx 891O2uqQAeKWiCdBU+tSzlpT+n19HwPgVHaEH5YpyjgR1aNbP0kLS1xzJm0JjGDEn0Pg pngml3uLeP12nEU4AtTRreovPeoaaBTn9g4h3gmgI+OHZh+7+OlOuhsBy2XJ3bOPG9Ao p0c+lMtUCsTr4sqwHV65mVZeNnyPJ+KngwLCoLfZJv8AYWtK8+xoiQrc5iLIV+1bKCHT sC5s5tSCIGGZruzfPa8PzUxOqQdebAnl6u2s+eOmiJosP4QAZHNTBGEv8JiWnm6bzkCH 1myQ== X-Forwarded-Encrypted: i=1; AJvYcCVLL/x9l9RBs9VumgPuxg1ReYm92rBRAOnyVL+meCDwwdmndO99S85c1N/WG95WsXtus/qEWAtxZfXXv0HcAKIZ7sDkX3e5aeHZLigQ X-Gm-Message-State: AOJu0YyZZzohM5OZciOVez2K4VwO1NL90wiRJcbsvlo0aI0Y5xeS4mra fkHQ24G7N8YgIGRD0tgClcMX4wSVZfL3bIS4QpC9mG08D70wyBJFv4H7V20VxZN7DohNdbuv1UP MRBl2Df/9BKg6hPNNxyQhtkk5YL8= X-Google-Smtp-Source: AGHT+IGI593kAulQzKosc/NVoSfp9f4kqA95iWT0KgzwYnTLH0JVLJrryOJ84m4IaOMo1AfruC/nAOtAmtYO+Fcnwl0= X-Received: by 2002:a05:6871:8a0:b0:254:e89e:fc1d with SMTP id 586e51a60fabf-25db35cc523mr4707380fac.51.1719803736205; Sun, 30 Jun 2024 20:15:36 -0700 (PDT) MIME-Version: 1.0 References: <1362410.1719349169@sss.pgh.pa.us> <1390099.1719357084@sss.pgh.pa.us> <1642803.1719447063@sss.pgh.pa.us> In-Reply-To: From: "David G. Johnston" Date: Sun, 30 Jun 2024 20:14:58 -0700 Message-ID: Subject: Re: Should we document how column DEFAULT expressions work? To: David Rowley Cc: Peter Eisentraut , Tom Lane , James Coleman , pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000c7b144061c2702c7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c7b144061c2702c7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Jun 30, 2024 at 7:52=E2=80=AFPM David Rowley = wrote: > 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. > > I'm game. If anyone is using the ambiguous spelling it is probably to their benefit to have it break and realize they wanted a function expression, not a constant expression. David J. --000000000000c7b144061c2702c7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Jun 30, 2024 at 7:52=E2=80=AFPM David Rowley <<= a href=3D"mailto:dgrowleyml@gmail.com">dgrowleyml@gmail.com> wrote:<= /span>
If that's the case, maybe a tiny step towards w= hat Peter proposed is
just to make trailing punctuation fail for timestamp special values in
v18.


I'm game. If anyone is usin= g the ambiguous spelling it is probably to their benefit to have it break a= nd realize they wanted a function expression, not a constant expression.

David J.

--000000000000c7b144061c2702c7--