working with arrays question

From: "Joel Joseph" <jjoseph(at)telusplanet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: working with arrays question
Date: 2002-08-07 02:26:45
Message-ID: Fz%39.9758$X5.1222063@news2.telusplanet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a simple question that I just can't get an answer to by looking at
the documentation online. Maybe someone can help me out here. Here is the
question. In plpgsql how do you set an element in an array. What I want to
do is for example:

function ...
declare
afloat float[]; -- array of float

begin
afloat[0] = 0.0; -- this fails, how do I do this?
end;

--

Any help would be appreciated. Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-08-07 03:47:00 Re: inet <<= and indexes
Previous Message Alvaro Herrera 2002-08-06 23:42:49 Re: COPY