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