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

Поиск
Список
Период
Сортировка
От Aleksej Butylkin
Тема BUG #4497: array of user defined domains can't be passed to function
Дата
Msg-id 200810250831.m9P8VQq0012591@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4497: array of user defined domains can't be passed to function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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 "["

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

Предыдущее
От: ""
Дата:
Сообщение: BUG #4496: Memory leak in pg_dump.c?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4497: array of user defined domains can't be passed to function