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 1wfNxr-005QMk-08 for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Jul 2026 20:24:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wfNxp-0030e4-2p for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Jul 2026 20:24:49 +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 1wfNxp-0030dv-1f for pgsql-hackers@lists.postgresql.org; Thu, 02 Jul 2026 20:24:49 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wfNxm-00000001OpC-3fmU for pgsql-hackers@postgresql.org; Thu, 02 Jul 2026 20:24:48 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-698b6c87884so1661146a12.2 for ; Thu, 02 Jul 2026 13:24:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783023886; cv=none; d=google.com; s=arc-20260327; b=geQH9KeoEOCeTmAXj91axX+451SnOHjtnc3T/PR2j6H0k5KfhvB74jc1nGeT+WkauV QUat5Ysn8C2yir3bSxB2DXFPuPfyZOXaCJZ/fV9E85R2u9jHBCok5NZ32kORl/ZpRaVj 1r6Bb+JPFJ7H1ZmkqVbQ+Ms1z5aHjAsv3Eu4elXlbF3zmEoEfy2W/05fS5FZCb1rHaYh My/dXb5VWLg/8lXj0+B56B0hgXdbwDafSB3Gm6yGox3w5xSUNfoQz4vpQDa/l2QhkfXE gqnG8lDeJRn+236Nd0+ZT+Y2fkEFYATOy3T8ZSAAVP4skyls/rmGjejV+R9sGPc+2EIv 1Sxg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=6x4AKqGM0uDf8CbAjs5hgWZ4lHH+nvahw/4bTQ/OSuc=; fh=db1oFg9+7pwi94XvW9jfPfCbgCO5EEWSrMooHOfqAsM=; b=smYljKxJCPmv3wwClaxtJcmb8ANCN0QZiHYYLJKoGbO1pKAnYVidsrngbsrprZcH7a stVaT7rc1ksa9x0yFN0f5ri6i5Sy6teP7xAttxwFSA1qBixKUfMtsy3vRPX+dHNgMBvT +i7Tt894hHF/TtIR1e6PqqXFsX+WbJaT+C/xJ5kNejg39fVOCOa+5lkqi8yc5hTsLc+i cA+a+dsAKiygZnsBQY4VZp5SHtFAof9Fv0uHK6EGUDsCaPBx2uE29QIpoffTymTK/DpD i5mM6t0IIH+qbqpSbiSXTSAPgXnbZpxDUzq+nlg+iFUb79ptMK5tVFY+uXFyrD84REo2 OmEA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783023886; x=1783628686; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=6x4AKqGM0uDf8CbAjs5hgWZ4lHH+nvahw/4bTQ/OSuc=; b=jBvfbE+yan1zHLu/wbUMUMAXKLblIAcd8JkKWX0lpyK5ve5lGWvt6LIgk/Znbin4yv imutGagtEDxx5M7Xdy15aEvOP254S64vhN9DlXw8tn10XVUDb0mzFV/tOimQAHCutJv6 U2xe9bjgq0XzARxbBaUSy0UASijuhQC5gzArrrrdNQnGqjWPra4KZ74vUJqHa6jKOX31 9Z2CJnBEAm4Zi/ayD66qQId6JE5lpzq8ec8SHIXAY0eghUZ9MyatGaBmxCpAfkfJIeVW CCrPrEl3TqWNc9q6E/Ty10AeHS3GC0qMcu03hYl+kAMf9Mr2ZeUhPGEr6nwjTrmc25LS 71rA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783023886; x=1783628686; h=content-transfer-encoding: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=6x4AKqGM0uDf8CbAjs5hgWZ4lHH+nvahw/4bTQ/OSuc=; b=Jt8S5EQLP7QieRLCI9gLTxmBFH3+BUvM4nMhfPHKAWNb/je9D4rLp/ph6zcJKAPNHw J/lD6W136mKQ32vNzJLjVg1/R4isawguzMUGN5VKPAmk5SglpU//JfwdINxrusGRZ5Do Wnm+RbInyRidUJd8ITP/LDCGxTMIxx9x+dlmIXvC9rf3VtFuYUAhtGMvWw9/ppWyUCA1 MusYA72uSjg1Vzf9hYncGBtonPbNklesVPYPZgkvmMCx+Zoh50OxBqrxbhT9NUHDb55t 1FJrZ5jCAl2bxOLrih1ezFlp9oWBoeEtPIXw1QiBkKJ4cRCY7A9Bo6q1R/81fNHDSlKf s4pw== X-Forwarded-Encrypted: i=1; AHgh+RrsqpEhLJJBWKFXFspgaEteknTQdVI5/WsVebuu7PuziEC0oT6z0tF0SRG58icTc1GOP33w8WE3HK1b0zJR@postgresql.org X-Gm-Message-State: AOJu0YwCr8tMyCeXSiLvF5PeMlcD8cGB4ztBUo9hhBtCy5yoTd+mlnkQ xGQ5m/cMmK1/80I7oJQ7YFHl2/e106pfthlipjok+y910988HJorHbws82+4LHwFFcyKWWmzUtv NmdT9EOQrKXvpZ4AZvDDCn8A3zbv5gjc= X-Gm-Gg: AfdE7ck0ASGU2SK+N8QRzN1wJUJi26pnAsbw3xsrv+tkYcgBdczfQ3q74VEZzQKU01o MxGzo9jF4Qlug4hnt9//T83Q2biH6AuGtaIvks5bQj9+cOwf3d7IBCIFJgl6KWy3bdExAsbovF/ qpqcmdqRtUZClHn8WNSu8nXG/Rg/+YPCQdOy7xfagVAvhpw13EHBCEFl1aV/+YqgSbAzZLzYzsl yjiNuUou2crEqdkGhHwxqzAzrjjBmhtJTXd794kNckcd71IEN6St4So5UlvmAcbmOmLtMLoSrp7 20NfFuEPfM94PWiWGRSUW+VxhxU/tHVjvwKtju0= X-Received: by 2002:a17:907:948c:b0:c12:7476:8913 with SMTP id a640c23a62f3a-c12ae4735b2mr347870666b.11.1783023885612; Thu, 02 Jul 2026 13:24:45 -0700 (PDT) MIME-Version: 1.0 References: <82b4223e-84d4-432d-8167-dd698ce489f5@postgresfriends.org> <1be5fcb4-683d-4ad0-b327-a34092e09504@eisentraut.org> In-Reply-To: <1be5fcb4-683d-4ad0-b327-a34092e09504@eisentraut.org> From: Robert Haas Date: Thu, 2 Jul 2026 16:24:32 -0400 X-Gm-Features: AVVi8CdEejTlVfurQD1P59_PpT29brkjHxowKWFV7JIhg-10fUYCfQAbDpRQf6w Message-ID: Subject: Re: implement CAST(expr AS type FORMAT 'template') To: Peter Eisentraut Cc: Corey Huinker , jian he , Zsolt Parragi , Vik Fearing , "David G. Johnston" , PostgreSQL-development Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 2, 2026 at 11:13=E2=80=AFAM Peter Eisentraut wrote > I don't really understand the purpose of this feature to begin with. > You can already call the formatting functions directly. Does this cast > syntax offer anything on top of that? Standards compliance, maybe? I don't know what else there could be. --=20 Robert Haas EDB: http://www.enterprisedb.com