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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: When replication?
Следующее
От: Ken Corey
Дата:
Сообщение: Re: Easy way to call a plpgsql function?