RE : Is the use of array as PL/PGSQL function arguments ?

Поиск
Список
Период
Сортировка
От Bruno BAGUETTE
Тема RE : Is the use of array as PL/PGSQL function arguments ?
Дата
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAmshpsd0uMk2no/dKCg1D8gEAAAAA@baguette.net
обсуждение исходный текст
Ответ на Re: Is the use of array as PL/PGSQL function arguments ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: RE : Is the use of array as PL/PGSQL function arguments
Список pgsql-general
> > CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[],
> > events.id%TYPE) RETURNS BOOLEAN AS '
>
> You can certainly use arrays as arguments, but I don't think
> you can combine %TYPE with [] like that.

Thanks Tom for the information ! :-)

When I create functions with %TYPE, PostgreSQL replies that it will
convert the %TYPE with a VARCHAR (for example). So it could replace a
%TYPE[] by a VARCHAR[] (in my example) ?

It seems that this modification could be done easily, I will try to find
in the source code to create this patch. (Without any warranties, I
never done a patch for PostgreSQL).

In the meantime, is it possible to add this feature in the TODO list ?

Regards,

---------------------------------------
Bruno BAGUETTE - pgsql-ml@baguette.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Thierry Missimilly
Дата:
Сообщение: Re: Can anyone recommend a good PostGres admin tool?
Следующее
От: "My Internet"
Дата:
Сообщение: Type of application that use PostgreSQL