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

Lists: pgsql-bugs
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
Lists: Postg범퍼카 토토SQL : Postg범퍼카 토토SQL 메일 링리스트 : 2008-10-25 이후 PGSQL-BUGS 08:31


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


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Aleksej Butylkin" <aleboo(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4497: array of user defined domains can't be passed to function
Date: 2008-10-25 12:00:13
Message-ID: 26893.1224936013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Aleksej Butylkin" <aleboo(at)gmail(dot)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