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

>>>>> "Praveen" == Praveen Kumar <praveenkumar52028@gmail.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)