Horton

Re: transforms

Chapman Flack <jcflack@acm.org>

View thread View on postgr.es
From: Chapman Flack <jcflack@acm.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter@eisentraut.org>, Pavel Stehule <pavel.stehule@gmail.com>
Date: 2025-04-19T23:50:47Z
Lists: pgsql-hackers 
On 04/19/25 19:32, Chapman Flack wrote:
> On 04/19/25 19:12, Tom Lane wrote:
>> You could argue that
>> CREATE FUNCTION foo(anyelement) RETURNS anyelement
>> TRANSFORM FOR TYPE int
>> AS ...;
>> should mean that if the actual argument type is int, then the
>> mentioned transform should be applied to the input and result;

Also if foo() RETURNS TRIGGER and tg_trigtuple/tg_newtuple have
int components.

Regards,
-Chap

Commits

  1. Fix erroneous construction of functions' dependencies on transforms.

  2. Change SQL-language functions to use the plan cache.