Re: Arrays in pl/pgsql functions - Mailing list pgsql-admin

From Tom Lane
Subject Re: Arrays in pl/pgsql functions
Date
Msg-id 5658.1058465922@sss.pgh.pa.us
Whole thread Raw
In response to Arrays in pl/pgsql functions  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
"Donald Fraser" <demolish@cwgsy.net> writes:
> CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
> DECLARE
>      test int4[];
> BEGIN
>     test[1] := 1;
>     RETURN test;
> END ' LANGUAGE 'plpgsql';

> If I try to execute this function I get:
> WARNING:  plpgsql: ERROR during compile of test_arrays near line 5
> ERROR:  syntax error at or near "["

Existing releases of plpgsql don't support assignment to array elements.
I believe Joe Conway has fixed this for 7.4, though.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Re: Arrays in pl/pgsql functions
Next
From: Tom Lane
Date:
Subject: Re: pg_dump: dumpBlobs(): error reading large object: ERROR: