SELECT INTO an array

From: Alberto Bolchini <alberto(at)melloni49(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: SELECT INTO an array
Date: 2002-05-03 15:03:13
Message-ID: 1.0.2.200205031702.9711@melloni49.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi!

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 ...;

when calling the function, I get a

ERROR: array_in: Need to specify dimension

How do I specify such dimension?

Thanks
Alberto

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Slawek Jarosz 2002-05-03 15:47:18 Forte for Java & Postgres
Previous Message Tom Lane 2002-05-03 14:18:00 Re: