updated at a single element in a array using pl/pgsql - Mailing list pgsql-general

From Cristian Custodio
Subject updated at a single element in a array using pl/pgsql
Date
Msg-id 001101c2e8b9$731ba2e0$fb01a8c0@ttcristian
Whole thread Raw
Responses Re: updated at a single element in a array using pl/pgsql  (Dennis Gearon <gearond@cvc.net>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with pg_dump
Next
From: "scott.marlowe"
Date:
Subject: Re: Getting Started in Postgresql