BUG #4497: array of user defined domains can't be passed to function
От | Aleksej Butylkin |
---|---|
Тема | BUG #4497: array of user defined domains can't be passed to function |
Дата | |
Msg-id | 200810250831.m9P8VQq0012591@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4497: array of user defined domains can't be passed to function
|
Список | 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 по дате отправления: