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