From: | ramsiddu007 <ramsiddu007(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Function Overloading |
Date: | 2018-05-24 12:57:14 |
Message-ID: | CA+zEy78T5P9rZ7V6mkkENb_U_bveOy1eOu1S97oWxeTXm86Cmg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Professionals,
I hope you are all doing good. Actually I got one problem. I
have 2 functions like below. Those are having 11 and 14 parameters with
commonly last parameter is variadic array type.
func_get_item_list_phy_param(smallint, numeric, numeric, character varying,
character varying, character varying, numeric, character varying, integer,
integer, character varying[]);
func_get_item_list_phy_param(smallint, numeric, numeric, character varying,
character varying, character varying, numeric, character varying, integer,
integer, character varying, character varying, character varying, character
varying[]);
Now I have called 14 parameters function like
select * from
epps.func_get_item_list_phy_param('1'::smallint,'1.0'::numeric,'1550.0'::numeric,'HR
HOT'::varchar,NULL::varchar,NULL::varchar,'1400.0'::numeric,'192.168.1.29'::varchar,'32272'::int,'119'::int,'c'::varchar,'b'::varchar,'a'::varchar,
null) as result
After that it was showing following error:
*HINT: Could not choose a best candidate function. You might need to add
explicit type casts.*
After that I have removed variadic input parameter at last then again run.
But it's calling 11 parameter procedure.
select * from
epps.func_get_item_list_phy_param('1'::smallint,'1.0'::numeric,'1550.0'::numeric,'HR
HOT'::varchar,NULL::varchar,NULL::varchar,'1400.0'::numeric,'192.168.1.29'::varchar,'32272'::int,'119'::int,'c'::varchar,'b'::varchar,'a'::varchar)
as result
Plz give me clarity of actual issue in these cases.
I hope, I'll get some response from you.
Thanks in advance.
--
*Best Regards:*
Ramanna Gunde
From | Date | Subject | |
---|---|---|---|
Next Message | Marina Polyakova | 2018-05-24 13:00:33 | Re: WIP Patch: Precalculate stable functions, infrastructure v1 |
Previous Message | Pavel Raiskup | 2018-05-24 12:01:00 | Re: Shared PostgreSQL libraries and ABI versioning |