Обсуждение: BUG #4497: array of user defined domains can't be passed to function

Поиск
Список
Период
Сортировка

BUG #4497: array of user defined domains can't be passed to function

От
"Aleksej Butylkin"
Дата:
The following bug has been logged online:

Bug reference:      4497
Logged by:          Aleksej Butylkin
Email address:      aleboo@gmail.com
PostgreSQL version: 8.3.4
Operating system:   Windows XP SP3
Description:        array of user defined domains can't be passed to
function
Details:

I have specified a domain and trying to pass array of it into a function but
without success.
An code example must receive array of user defined domain, but instead error
appears:
ERROR:  type t_my_dom[] does not exist

-----
create domain t_my_dom as varchar(32);

create function sp_test(
    p_data t_my_dom[]
) returns void
as $$
begin
    return;
end;
$$language plpgsql;
-----

Second example tries to reference domain from function with %TYPE syntax
without success too:
-----
create domain t_my_dom as varchar(32);
create table test(
value t_my_dom
);

create function sp_test(
    p_data test.value%type []
) returns void
as $$
begin
    return;
end;
$$language plpgsql;
-----
At this time error looks like:

ERROR: syntax error at or near "["

Re: BUG #4497: array of user defined domains can't be passed to function

От
Tom Lane
Дата:
"Aleksej Butylkin" <aleboo@gmail.com> writes:
> I have specified a domain and trying to pass array of it into a function but
> without success.

Per the fine manual:
    Arrays of domains are not yet supported.
http://www.postgresql.org/docs/8.3/static/arrays.html

            regards, tom lane