Re: plpgsql and setting array values. - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql and setting array values.
Date
Msg-id 20888.1048544805@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql and setting array values.  ("Nicolai Petri" <lists@petri.cc>)
List pgsql-general
"Nicolai Petri" <lists@petri.cc> writes:
> The problem is that i cannot assign values to explicit array values like
> myarray[2]:=123;

Yeah, plpgsql doesn't support that (subscripting the assignment
destination).  It's been on the to-do list for awhile, but hasn't risen
to the top of anyone's queue I guess.  One thing that's not real clear
is what the semantics should be --- the equivalent cases at the SQL
level aren't super friendly, either.

            regards, tom lane


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: fairly current mysql v postgresql comparison need for
Next
From: Joe Conway
Date:
Subject: Re: PL/Java (was: stored procedures)