The following bug has been logged online:
Bug reference: 5171
Logged by: Jason
Email address: jason(at)beanfield(dot)com
PostgreSQL version: 8.4
Operating system: FreeBSD
Description: Composite type with array does not translate in
plpythonu
Details:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.
create type test_array as (
col1 text[]
);
create function return_array(val1 text, val2 text) returns test_array
as $$
return {'col1': [val1, val2]}
$$ language plpythonu;
select return_array('test1','test2')
ERROR: missing dimension value
********** Error **********
ERROR: missing dimension value
SQL state: 22P02