From: Arve Fahlvik <afa@vivatech.no>
To: pgsql-sql@postgresql.org
Subject: Re: Assign values to array
Date: Thu, 20 Jun 2002 16:56:06 +0200
Message-ID: <3D11ED06.80706@vivatech.no> (raw)
References: <200206192039.g5JKd8q22527@server236a.web2wap.no>
<3D11D8D7.7060906@asti.dost.gov.ph>
Thanks
I can see the logic now, but have still problems.
declare
t integer[3];
begin
t[1]:='{4}';
return 0;
end;
apollo3-stat=# select test();
NOTICE: plpgsql: ERROR during compile of test near line 4
ERROR: parse error at or near "["
apollo3-stat=#
Joseph Syjuco wrote:
> try out
> t[1]:='{4}'
> afa wrote:
>
>> 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
>> -------------------------------------------------------------------
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: afa@vivatech.no
Subject: Re: Assign values to array
In-Reply-To: <3D11ED06.80706@vivatech.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox