Need help on updating an entire column with a list of values, I have.
От | Rajan, Pavithra |
---|---|
Тема | Need help on updating an entire column with a list of values, I have. |
Дата | |
Msg-id | BE29E09321056B4C9082D207759A692801DADC1E@EXCHMB01.conedison.net обсуждение исходный текст |
Ответы |
Re: Need help on updating an entire column with a list of
values, I have.
Re: Need help on updating an entire column with a list of values, I have. Re: Need help on updating an entire column with a list of values, I have. |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: