Re: Problem with selecting arrays in set-returning plpgsql function - Mailing list pgsql-general

From Rory Campbell-Lange
Subject Re: Problem with selecting arrays in set-returning plpgsql function
Date
Msg-id 20110803065817.GA29382@campbell-lange.net
Whole thread Raw
In response to Problem with selecting arrays in set-returning plpgsql function  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
On 02/08/11, Rory Campbell-Lange (rory@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 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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Timeline Conflict
Next
From: "Albe Laurenz"
Date:
Subject: Re: pg_largeobject vs pg_toast_XXXX