Re: [GENERAL] Problem with selecting arrays in set-returning plpgsql function

2011-08-03 Thread Rory Campbell-Lange
On 02/08/11, Rory Campbell-Lange (r...@campbell-lange.net) 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

[GENERAL] Problem with selecting arrays in set-returning plpgsql function

2011-08-02 Thread Rory Campbell-Lange
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