Re: Need help on updating an entire column with a list of values, I have.

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Need help on updating an entire column with a list of values, I have.
Дата
Msg-id e4edc9361003260714tfa297dfjafed95eb916aac93@mail.gmail.com
обсуждение исходный текст
Ответ на Need help on updating an entire column with a list of values, I have.  ("Rajan, Pavithra " <RAJANP@coned.com>)
Список pgsql-general


2010/3/26 Rajan, Pavithra <RAJANP@coned.com>

Hello - I have this table with 90 rows, which contains 2 columns ,column A (type 'numeric') and column B(type text) . Column 'A' is filled with a constant number and column 'B' has an unique entry for each row.

E.g.              A                 B
         (numeric)        (text)
           
            15968.0           002
        15968.0           003
        15968.0           004
        15968.0           011
        15968.0           012
        15968.0           057
        15968.0           006
        15968.0           009
        15968.0           010
             ..
             .. 
I would here want to update the entire column A with a list of values that I have.( 06959.0,15308.0,15968.0,18916.2,19961.0,26528.0,29553.0,29872.0,30631.0 …).How do I accomplish this? Thank you.

         


Hi,
what is the relation between current data and the data that you have in the list? How do you want to update those values? Where should be the value 06959.0 and where 29872.0?

regards
Szymon Guz

В списке pgsql-general по дате отправления:

Предыдущее
От: Ozz Nixon
Дата:
Сообщение: Re: Does anyone use in ram postgres database?
Следующее
От: "Rajan, Pavithra "
Дата:
Сообщение: Re: Need help on updating an entire column with a list of values, I have.