| From: | "Rajan, Pavithra " <RAJANP(at)coned(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Need help on updating an entire column with a list of values, I have. |
| Date: | 2010-03-26 13:47:33 |
| Message-ID: | BE29E09321056B4C9082D207759A692801DADC1E@EXCHMB01.conedison.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Lopes | 2010-03-26 13:52:01 | How to write Rules on a View to allow all actions as in the physical table? |
| Previous Message | Frans Hals | 2010-03-26 11:07:19 | Re: Large index operation crashes postgres |