Easy way to call a plpgsql function?
От | Ken Corey |
---|---|
Тема | Easy way to call a plpgsql function? |
Дата | |
Msg-id | 0102060756570M.18716@kenlinux.bithub.org обсуждение исходный текст |
Ответы |
Re: Easy way to call a plpgsql function?
|
Список | pgsql-novice |
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.
В списке pgsql-novice по дате отправления: