BUG #4497: array of user defined domains can't be passed to function - Mailing list pgsql-bugs

From Aleksej Butylkin
Subject BUG #4497: array of user defined domains can't be passed to function
Date
Msg-id 200810250831.m9P8VQq0012591@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4497: array of user defined domains can't be passed to function  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: ""
Date:
Subject: BUG #4496: Memory leak in pg_dump.c?
Next
From: Tom Lane
Date:
Subject: Re: BUG #4497: array of user defined domains can't be passed to function