Re: Updating Arrays

> -----Original Message----- From: Merlin Moncure
> Sent: Monday, August 22, 2011 11:03 AM
> To: Bob Pawley
> Cc: Postgresql
> Subject: Re: [GENERAL] Updating Arrays
>
> On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
>>
>> Hi
>>
>> I exploring the use of arrays.
>>
>> So far I have created a table and inserted a row and updated the row with
>> an
>> array
>> Update library.compare
>>  set _base =
>>  '{2, 0.764149497122068, 4.8886}'
>>  where process_id = 2;
>> – successfully.
>>
>> However when I attempt to update a specific element of the array
>>
>> Update library.compare
>> set _base[2] =
>> '{2}'
>> where process_id = 2;
>> I get an error “invalid input syntax for type numeric: "{2}"”
>
> try "set base[2]  = 2"
>
On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> I'm not sure what you mean.
>
> _base -- not base -- is the column name.

oops. anyways, the important point is on the right side of the equals sign.

Update library.compare set _base[2] = 2 where process_id = 2;

(also, please try to avoid top posting)

merlin