Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)
Date
Msg-id 1683365.1651424937@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)
List pgsql-bugs
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sun, May 1, 2022 at 8:44 AM d <dchuck@yurfish.com> wrote:
>> CREATE OR REPLACE FUNCTION record_to_form_data(p_r record)

> Not a bug, it is a documented limitation.

FWIW, it does seem to work as desired if you declare the argument as
"anyelement".

Maybe we could improve this situation by treating a "record" parameter
as polymorphic, though that might cause some odd inconsistencies with
plpgsql's historical treatment of "record" local variables.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)
Next
From: "David G. Johnston"
Date:
Subject: Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)