plpgsql: support identif%TYPE[], (from ToDo)

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
plpgsql: support identif%TYPE[], (from ToDo)
Дата
Msg-id
162867790907281353q65ac87fx205029b224353b03@mail.gmail.com
Список
Дерево обсуждения
plpgsql: support identif%TYPE[], (from ToDo) Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql: support identif%TYPE[], (from ToDo) Martijn van Oosterhout <kleptog@svana.org>
Re: plpgsql: support identif%TYPE[], (from ToDo) Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql: support identif%TYPE[], (from ToDo) Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql: support identif%TYPE[], (from ToDo) Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql: support identif%TYPE[], (from ToDo) Robert Haas <robertmhaas@gmail.com>
Re: plpgsql: support identif%TYPE[], (from ToDo) Pavel Stehule <pavel.stehule@gmail.com>
Hello

I would to solve some points from ToDo. I began with TYPE [] support.
I thing, so this should be relative simple, but there are one issue.

There are syntax for declare array from scalar type -

create or replace function x(a int)
returns ... as $$
declare f a%type[] <--
begin ...

but there are not syntax for inversion - scalar from array.
Theoretically we could to define variable with same type (array) and
everywhere work with first element. Or we should to define some
syntax:

My first idea is using word element:

create or replace function x(a int[])
...
declare f a%element;
begin
...

any ideas?

regards
Pavel

В списке pgsql-hackers по дате отправления
От: pgsql@mohawksoft.com
Дата:
От: Euler Taveira de Oliveira
Дата:
FAQ