updated at a single element in a array using pl/pgsql
Can I update a single element in a array?
CREATE OR REPLACE FUNCTION TESTEARRAY() RETURNS CHAR AS '
DECLARE
v_array integer[];
BEGIN
v_array[1] := 10; -- Parser error at or near ''[''
RETURN v_array[1];
END;
'language 'plpgsql';
Cristian
All this talk about arrays is that they are finally in pl-pgsql? useful feature! I thought that
arrays were some kind of extension to SQL.
3/12/2003 9:04:23 AM, "Cristian Custodio" <crstian@terra.com.br> wrote:
Show quoted text
Can I update a single element in a array?
CREATE OR REPLACE FUNCTION TESTEARRAY() RETURNS CHAR AS '
DECLARE
v_array integer[];
BEGIN
v_array[1] := 10; -- Parser error at or near ''[''
RETURN v_array[1];
END;
'language 'plpgsql';Cristian
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?