Function Overloading

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

Responses

Browse pgsql-hackers by date

  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