[GENERAL] Updating Arrays

2011-08-22 Thread Bob Pawley
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

Re: [GENERAL] Updating Arrays

2011-08-22 Thread Merlin Moncure
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley rjpaw...@shaw.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; –

Re: [GENERAL] Updating Arrays

2011-08-22 Thread Bob Pawley
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 rjpaw...@shaw.ca

Re: [GENERAL] Updating Arrays

2011-08-22 Thread Merlin Moncure
-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 rjpaw...@shaw.ca wrote: Hi I exploring the use of arrays. So far I have created

Re: [GENERAL] Updating Arrays

2011-08-22 Thread David Johnston
-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 rjpaw...@shaw.ca wrote: Hi I exploring the use of arrays. So far I have created

Re: [GENERAL] Updating Arrays

2011-08-22 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley rjpaw...@shaw.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] =