Re: how can I select into an array?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: Andy Kriger <akriger(at)greaterthanone(dot)com>, 'Pgsql-General' <pgsql-general(at)postgresql(dot)org>
Subject: Re: how can I select into an array?
Date: 2004-02-06 19:04:00
Message-ID: 4023E520.7060003@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule wrote:
> if you can in plpgsql 7.2.x return array of known type, you can replace
> anyarray and anyelement like varchar[], varchar. But I don't know if it
> 7.2 supported.

PL/pgSQL array support in anything earlier than 7.4 is pretty weak. I
would strongly recommend upgrading to 7.4 if arrays are important to you.

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-02-06 19:19:23 Re: PL/Ruby
Previous Message Stephan Szabo 2004-02-06 18:58:12 Re: Indexes and sorting