Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)
Дата
Msg-id 1683365.1651424937@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
"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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: ERROR: type of parameter 1 (fruit2) does not match that when preparing the plan (fruit1)