Re: plpgsql and setting array values.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nicolai Petri" <lists(at)petri(dot)cc>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql and setting array values.
Date: 2003-03-24 22:26:45
Message-ID: 20888.1048544805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nicolai Petri" <lists(at)petri(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hewi Yoatl 2003-03-24 22:32:43 database migration
Previous Message Joe Conway 2003-03-24 22:25:34 Re: [GENERAL] PL/Java (was: stored procedures)