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

On 02/08/11, Rory Campbell-Lange (rory(at)campbell-lange(dot)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 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