Easy way to call a plpgsql function?

Поиск
Список
Период
Сортировка
Искать
От
Ken Corey
Тема
Easy way to call a plpgsql function?
Дата
Msg-id
0102060756570M.18716@kenlinux.bithub.org
Список
Дерево обсуждения
Easy way to call a plpgsql function? Ken Corey <ken@kencorey.com>
Re: Easy way to call a plpgsql function? Ken Corey <ken@kencorey.com>
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
Дата:
FAQ