updated at a single element in a array using pl/pgsql

From: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: updated at a single element in a array using pl/pgsql
Date: 2003-03-12 17:04:23
Message-ID: 001101c2e8b9$731ba2e0$fb01a8c0@ttcristian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-03-12 17:23:24 Re: Getting Started in Postgresql
Previous Message Leigh W3NLB 2003-03-12 17:03:40 Re: Largest filesize under Linux