On 02/08/11, Rory Campbell-Lange (rory@xxxxxxxxxxxxxxxxxx) wrote:
> I am trying to select arrays in a set-returning function, but receiving
> the error: "array value must start with "{" or dimension information".
>
> This issue appears to relate to locationnodes.rs_people_c sometimes
> having an empty array. The return type into which
> locationnodes.rs_people_c is returned is INTEGER[].
My mistake was due to creating another return type expecting an array,
which received a simple INT.
Now sorted.
Rory
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
