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 "["