plpython returns integer[] fails for multi-dimensional array - Mailing list pgsql-general

From TJ O'Donnell
Subject plpython returns integer[] fails for multi-dimensional array
Date
Msg-id AANLkTinhAi65eCG4zLYrmR-uYS1i_0pJ9he-6_Vo4DKx@mail.gmail.com
Whole thread Raw
Responses Re: plpython returns integer[] fails for multi-dimensional array  (Thom Brown <thom@linux.com>)
Re: plpython returns integer[] fails for multi-dimensional array  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
In postgresql-9.0.1 I have to modify my plpython functions that return arrays.
It seems one dimesional arrays are handled properly, but not
2-dimensional arrays.

create or replace function atest() returns integer[] as $eopy$
 a = list()
 a.append(1)
 a.append(2)
 a.append(3)
 #return a works fine
 b = list()
 b.append(a)
 b.append(a)
 # error
 return b
$eopy$ language plpythonu


select atest() gives
obtest=# select atest();
ERROR:  invalid input syntax for integer: "[1, 2, 3]"
CONTEXT:  while creating return value
PL/Python function "atest"

How can I return multi-dimensional arrays in plpython?

TJ O'Donnell

pgsql-general by date:

Previous
From: Ben Carbery
Date:
Subject: Re: Understanding PG9.0 streaming replication feature
Next
From: Thom Brown
Date:
Subject: Re: plpython returns integer[] fails for multi-dimensional array