Re: Updating Arrays
От | Bob Pawley |
---|---|
Тема | Re: Updating Arrays |
Дата | |
Msg-id | 0AC12FCDAF7A4092A2429B599D1884E4@BobPC обсуждение исходный текст |
Ответ на | Re: Updating Arrays (Merlin Moncure <mmoncure@gmail.com>) |
Ответы |
Re: Updating Arrays
Re: Updating Arrays |
Список | pgsql-general |
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@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; > – 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: