Re: Updating Arrays
От
Merlin Moncure
Тема
Re: Updating Arrays
Дата
Msg-id
CAHyXU0znuFVo+LdjuRBKL-Vbhb2=3gVwxcusJ8JYEyNpVxLPXQ@mail.gmail.com
Ответ на
Updating Arrays (Bob Pawley)
Список
Дерево обсуждения
Updating Arrays "Bob Pawley" <rjpawley@shaw.ca>
Re: Updating Arrays Merlin Moncure <mmoncure@gmail.com>
Re: Updating Arrays "Bob Pawley" <rjpawley@shaw.ca>
Re: Updating Arrays David Johnston <polobo@yahoo.com>
Re: Updating Arrays Merlin Moncure <mmoncure@gmail.com>
Re: Updating Arrays Tom Lane <tgl@sss.pgh.pa.us>
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;
> – 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
В списке pgsql-general по дате отправления
