Arrays in pl/pgsql functions

Поиск
Список
Период
Сортировка
От Donald Fraser
Тема Arrays in pl/pgsql functions
Дата
Msg-id 005701c34c55$8d017540$1664a8c0@DEMOLITION
обсуждение исходный текст
Ответы Re: Arrays in pl/pgsql functions  (Joe Conway <mail@joeconway.com>)
Re: Arrays in pl/pgsql functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
PostgreSQL version 7.3.3

With reference to pl/pgsql functions.
I can declare a function to return an array type and I get no complaints when
defining or executing it.
I can declare a variable within the function as an array type and I don't get
any complaints defining or executing the function.
When I try to access the array I have problems.
I cannot find any documentation on accessing array types so I assumed they
would follow the pgSQL notation of for example:

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 "["

If I comment out the line:
test[1] := 1;
then the function executes ok.

Could someone be please inform me what the correct syntax for accessing arrays
is or tell me if its not possible with pl/pgSQL functions.

Thanks in advance,
Donald Fraser.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Dani Oderbolz
Дата:
Сообщение: Documentation of Concepts
Следующее
От: Sergio Pili
Дата:
Сообщение: pg_dump: dumpBlobs(): error reading large object: ERROR: