Hi All,
I'm trying to call a plpgsql function:
func(varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255));
With:
GRE=# select IU_EMPLOYEE ('f','f','f','f'',f','f','f','f','f','f','f');
ERROR: Function 'iu_employee(unknown, unknown, unknown, unknown, unknown,
unknown, unknown, unknown, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
GRE=#
I thought maybe overloading causes this...so I cast all the arguments as
varchars, and sure enough...
GRE=# select IU_EMPLOYEE (cast('f' as varchar),cast('f' as varchar),cast('f'
as varchar),cast('f' as varchar),cast('f' as varchar),cast('f' as
varchar),cast('f' as varchar),cast('f' as varchar),cast('f' as
varchar),cast('f' as varchar),cast('f' as varchar));
iu_employee
-------------
1
(1 row)
GRE=#
How can I tell plpgsql that an arg like 'f' means varchar (other than casting
it for every sql function call)?
--
Ken Corey, CTO Atomic Interactive, Ltd.