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

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Re: Problem with selecting arrays in set-returning plpgsql function
Дата
Msg-id 20110803065817.GA29382@campbell-lange.net
обсуждение исходный текст
Ответ на Problem with selecting arrays in set-returning plpgsql function  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Timeline Conflict
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: pg_largeobject vs pg_toast_XXXX