Re: BUG #15057: Issue with UNKNOW type when calling a PostgreSQL function from java code

>>>>> "Praveen" == Praveen Kumar <praveenkumar52028(at)gmail(dot)com> writes:

Praveen> ERROR: function decode(numeric, integer, unknown, unknown) does not exist
Praveen> LINE 1: select decode(lotid,1,'Lot Id Found','Lot Id not found') fro...
Praveen> ^
Praveen> HINT: No function matches the given name and argument types. You might
Praveen> need to add explicit type casts.

I can't reproduce that:

create function decode(anyelement,anyelement,text,text) returns void
language plpgsql
as $$
begin
raise info 'decode(anyelement,anyelement,text,text)';
end;
$$;
create function decode(numeric,integer,text,text) returns void
language plpgsql
as $$
begin
raise info 'decode(numeric,integer,text,text)';
end;
$$;

select decode(1::numeric, 1, 'foo', 'bar');
INFO: decode(numeric,integer,text,text)

Please show a COMPLETELY SELF-CONTAINED test case.

--
Andrew (irc:RhodiumToad)