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.96) (envelope-from ) id 1vTSA8-0022cK-27 for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Dec 2025 21:55:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTS98-001B67-0x for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Dec 2025 21:54:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTS97-001B5y-3C for pgsql-hackers@lists.postgresql.org; Wed, 10 Dec 2025 21:54:54 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vTS96-000312-1O for pgsql-hackers@lists.postgresql.org; Wed, 10 Dec 2025 21:54:54 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-3f11ad6e76fso237434fac.1 for ; Wed, 10 Dec 2025 13:54:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765403690; x=1766008490; darn=lists.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=8t9TcxWpZh6D3UkHaCTG6MP3I+CvG0xCdAJCVGOGjqY=; b=VADNIC2MP444/kwztsRxYVZxU2253d1ajuNDKJrHf0fHDTTgMjq4OhCeyLpKUaatba zQT5PVjNmk4U2Ag1vIXsDpS5OcXQIUWx/iblx6t3vvecQD1TYY0IjF5knrLikCn3aCE1 W6fxT5W7fMRanz/qnWBIHpY5RGlS75a2W3po9XYlFS95QywFcZYA01C63sDqf0Qm09BT SvAS7L8BdcKyPuL8tI64M+FISI2PxuBjRe6Mo3dl4XrRPlN0OCMh6cRyRjXhdxFbm08q g1XY4hBBaM3Xpf7SYs2+HNTxLCH1if2h3GDofcHrv5rT/X+C+l0gCvy/7Z/e5JiuZMVA M/7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765403690; x=1766008490; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=8t9TcxWpZh6D3UkHaCTG6MP3I+CvG0xCdAJCVGOGjqY=; b=cB4p/tG4xrer7Pq3cneUnqtMTzIjesBKbdgK63aqLIadIfrwWCkJ/Bzy4lgIrTioPp zWTB5eoTetwNnTyB/wxOWYwGCwVmgYcYwSbj6u6fiPRUJ+FQeCivEb3InLlvx1xbu9CA RZBF6kdSRJAac87QxyV++AGy4zCIBjFF1KEXLtXfIH/D35+dMItDiJZsUIwowEheclaR A7wQ3mpmjt8WSF2TQp0IMM39I+VXuqzQXkE7R1TkYmH+wsZiobHRh5JdOyPE1bNeiChP t8xK1apGL4VvrsHI2JKAq84vOmjsvSzzYtBYIsgMnNVip/tBeJm48qbAKz6/J4shqwZc 9WwA== X-Forwarded-Encrypted: i=1; AJvYcCU1m3ud1KEq1ykqC6ncMKqrIi8W6lRh0azrvwCS1V94Gj/7oxPSWJ0CdTZjslWGrHx2BVfx/FQERV6cD3OB@lists.postgresql.org X-Gm-Message-State: AOJu0YzMlA3lylhAPP/wAnyL9NCzCau1xxJEA9AocvLBdr+hw2UJ7aUJ oFs6pKOP+ajDrt46a4BFgd3Hgb9u4MFAw2foYq2JxjLDe8ShgjKnePEJ7RiR044GNkpxVWpNFhm 5vjxrU6DFdWUelcg1Fop8Lsg2o/XBAfRSq7/C X-Gm-Gg: ASbGncuXF/MBqOjVJBJNh9J10eTW2MdNxPlXa967saOogJTHf/uMRh3elnftc2wl6O9 j5ywQ3JI8SanU923iTLh8F3EJpr/tE8l2g/1ukwHkVaG1RE6LO/wyKFkH+JOyHdzMRhk76PwKtA qKeFQYAnXRGrPLzrfCNN3bUO2qrO65rYEnQaEnWJ2maTbh4dm1rpGRuHRmIefuREJYkPTIH8Ktq G8yWITY631ropDnTE8Rtmu27ggwxnE10NAFRbQFc9mXcto+sezhXJaFNs9Q/MqylO/0Tq03Wddt BX2RS7bYEPL0lrqLYcRSvsl9O/k= X-Google-Smtp-Source: AGHT+IE0Ur0QEj3vFD9579JZhUeBWUSnLgKunTQhWQ8Xx+Vf6d+9bbwTnMjgnqeEUM8xa76DnNeI2WUeRl4X0L8yi0o= X-Received: by 2002:a05:6820:4b87:b0:659:9a49:9081 with SMTP id 006d021491bc7-65b2ad3b08cmr2439303eaf.76.1765403690523; Wed, 10 Dec 2025 13:54:50 -0800 (PST) MIME-Version: 1.0 References: <04afcd1f-ed7d-4c0a-add1-50e3719ccbf9@postgresfriends.org> <762ae707-7fdc-43d8-a77a-3a10d12ce21d@postgresfriends.org> In-Reply-To: From: Corey Huinker Date: Wed, 10 Dec 2025 16:54:37 -0500 X-Gm-Features: AQt7F2qOR0Y7hhMx6hYs0fzIXtkGXeSbTGd2_Uhla9F1muZQ2wYE7kjtq6nbK78 Message-ID: Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions To: Kirill Reshke Cc: jian he , Vik Fearing , Isaac Morland , pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000dbe08a0645a0130c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dbe08a0645a0130c Content-Type: text/plain; charset="UTF-8" > > Overall, I think this patch is doing a good thing. Also, are we > holding it until the next SQL standard release, because sql/23 leaks > this feature? > The impression that I get is that the SQL Standard has become more descriptive and less prescriptive. It takes things that exist and builds the standard around those, so by implementing this draft feature, we help ensure that it makes it into the standard. This might be counter-intuitive, but that's what dictionaries do: they describe how the language is used (descriptive), rather than dictate how it should be used (prescriptive). --000000000000dbe08a0645a0130c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Overall, I think this patch is doi= ng a good thing. Also, are we
holding it until the next SQL standard release, because sql/23 leaks
this feature?

The impression that I get= is that the SQL Standard has become more descriptive and less prescriptive= . It takes things that exist and builds=C2=A0the standard around those, so = by implementing this draft feature, we help ensure that it makes it into th= e standard.

This might be counter-intuitive, but t= hat's what dictionaries do: they describe how the language is used (des= criptive), rather than dictate how it should be used (prescriptive).
<= /div>
--000000000000dbe08a0645a0130c--