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

Hello ,
Yes -I need to get the exact the same result as you had listed.Thanks.

________________________________

From: Timo Klecker [mailto:klecker(at)decoit(dot)de]
Sent: Friday, March 26, 2010 10:12 AM
To: Rajan, Pavithra ; pgsql-general(at)postgresql(dot)org
Subject: AW: [GENERAL] Need help on updating an entire column with a list of values, I have.

Hello,

what do you expect as Result? Something like this?

E.g. A B
(numeric) (text)

06959.0 002
15308.0 003
15968.0 004
18916.0 011
19961.0 012
26528.0 057
29553.0 006
29872.0 009
30631.0 010

Mit freundlichen Grüßen

Timo Klecker

Von: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] Im Auftrag von Rajan, Pavithra
Gesendet: Freitag, 26. März 2010 14:48
An: pgsql-general(at)postgresql(dot)org
Betreff: [GENERAL] Need help on updating an entire column with a list of values, I have.

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.