Assign values to array - Mailing list pgsql-sql

From afa
Subject Assign values to array
Date
Msg-id 200206192039.g5JKd8q22527@server236a.web2wap.no
Whole thread Raw
List pgsql-sql
Hello

I have made this simple test function:

declare
t integer[3];
u integer;
begin
u:=t[1];
t[1]:=4;
return 0;
end;

This is the results when i execute it:

apollo3-stat=# select test();
NOTICE:  plpgsql: ERROR during compile of test near line 6
ERROR:  parse error at or near "["
apollo3-stat=# 

This tells me that the assignment to u is ok.
How can i assign something to the t array?

I'm running versjon 7.2.1

afa

-------------------------------------------------------------------
-->> Add WEB ACCESS to your POP email accounts with
-->> FREE Perl CGI scripts! Download today! http://www.adjeweb.com
-------------------------------------------------------------------


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Which one is faster?
Next
From: Michael Agbaglo
Date:
Subject: Re: syntax for access an alias in the where clause ?