Re: SELECT INTO an array

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Alberto Bolchini <alberto(at)melloni49(dot)it>, pgsql-novice(at)postgresql(dot)org
Subject: Re: SELECT INTO an array
Date: 2002-05-03 16:54:44
Message-ID: web-1393116@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Alberto,

> I'm trying to write a PLPGSQL Function using an array as an internal
> variable, but I don't seem to succeed:
>
> CREATE FUNCTION ... RETURNS ... AS '
> DECLARE
> l_record integer[2];
> BEGIN
> SELECT INTO l_record col01, col02 FROM table01 WHERE ...;

You don't want an array for the above. You want a RECORD.

-Josh

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Alberto Bolchini 2002-05-03 17:41:38 [Fwd: Re: SELECT INTO an array]
Previous Message Slawek Jarosz 2002-05-03 15:47:18 Forte for Java & Postgres