Merlin Moncure writes:
> On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley 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;
Ri
> -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 wrote:
>> Hi
>>
>> I exploring the use of
> -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 wrote:
>>
>> Hi
>>
>> I exploring the
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 wrote:
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley 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;
> – successfu
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