Re: Updating Arrays

I'm not sure what you mean.

_base -- not base -- is the column name.

Bob

-----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"

merlin