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 1uhn5U-0047kZ-3z for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 10:34:08 +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 1uhn5T-007AqV-3b for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 10:34:07 +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.94.2) (envelope-from ) id 1uhn5S-007AqN-R1 for pgsql-hackers@lists.postgresql.org; Fri, 01 Aug 2025 10:34:06 +0000 Received: from relay7-d.mail.gandi.net ([217.70.183.200]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uhn5P-000BZQ-37 for pgsql-hackers@postgresql.org; Fri, 01 Aug 2025 10:34:06 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id 9B14642D7F; Fri, 1 Aug 2025 10:34:02 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=postgresfriends.org; s=gm1; t=1754044442; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=oE7aDGKNMIfDOQDzPra8Jjo5oNYablkTWbMWdSdMN9U=; b=odGn2Je2kIwqtUz3jwQW9LtGvsd42SXO0/5unQFF4Erfyux56WBUPEQgg4uLpC1zal+XEP LHfM6cU8KcPN/9OMwz4dTTH6YrXuhpj+UR9y7mcxBGiRnVeoLLheSkcWwtFvokcuSdTaLC 9Ms3cEsfzA97kig/sdUOwx4zlHuhqr2kxnVCiLh3qQ20f0DExBNWrcsZT+v/hQShM+fLJ4 gYVokkKMhOhVsOlyhaNjs3w2zagIAh0kOaJFJ7JBcYj8bVvEkXCGNfKuirttlXoUhncdeJ vesJoJ2CuerUuvtAXe7zX+FD3KPSkLlHfoyI7JuNdgOEzivkSWm5nhhGmhD77A== Message-ID: Date: Fri, 1 Aug 2025 12:34:02 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: implement CAST(expr AS type FORMAT 'template') To: jian he , "David G. Johnston" Cc: PostgreSQL-development References: <4c358bf8-87e8-4760-83d5-a6f9fcd88907@postgresfriends.org> <1b702de4-86b0-4144-a2d0-38266296894f@postgresfriends.org> Content-Language: en-US From: Vik Fearing In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-GND-State: clean X-GND-Score: -100 X-GND-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddutdefgeeiucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuifetpfffkfdpucggtfgfnhhsuhgsshgtrhhisggvnecuuegrihhlohhuthemuceftddunecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomhepgghikhcuhfgvrghrihhnghcuoehvihhksehpohhsthhgrhgvshhfrhhivghnughsrdhorhhgqeenucggtffrrghtthgvrhhnpeelteetkedtkefgueegueegtedtuefffefhffdvfedvjefhtefhgeeitdeugeevjeenucfkphepvdgrtddvmeekgedvkeemudduvgdtmedvjedtudemfedtkeehmeekugegleemkeeivgdtmeehheekieenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpedvrgdtvdemkeegvdekmeduudgvtdemvdejtddumeeftdekheemkegugeelmeekiegvtdemheehkeeipdhhvghloheplgfkrfggieemvdgrtddvmeekgedvkeemudduvgdtmedvjedtudemfedtkeehmeekugegleemkeeivgdtmeehheekiegnpdhmrghilhhfrhhomhepvhhikhesphhoshhtghhrvghsfhhrihgvnhgushdrohhrghdpnhgspghrtghpthhtohepfedprhgtphhtthhopehjihgrnhdruhhnihhvvghrshgrlhhithihsehgmhgrihhlrdgtohhmpdhrtghpthhtohepuggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhlrdgto hhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhg X-GND-Sasl: vik@postgresfriends.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 01/08/2025 10:22, jian he wrote: > should we first implement CAST(expr AS type FORMAT 'template') for limited types > (to_date, to_char, to_number, to_timestamptz) > or first try to make it more generic? My fear is that if we don't, it will never get done. -- Vik Fearing