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

From: "Aleksej Butylkin" <aleboo(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4497: array of user defined domains can't be passed to function
Date: 2008-10-25 08:31:26
Message-ID: 200810250831.m9P8VQq0012591@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4497
Logged by: Aleksej Butylkin
Email address: aleboo(at)gmail(dot)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 "["

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-10-25 12:00:13 Re: BUG #4497: array of user defined domains can't be passed to function
Previous Message dvice_null 2008-10-24 20:41:50 BUG #4496: Memory leak in pg_dump.c?