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

Hi again,

are there oids in your table or do you have any possibility to assure the
mentioned order of your data lines when you do a select?

If you can assure the order, you could use the temp table solution mentioned
by Grzegorz Jaśkiewicz.

If you cannot assure the order this could get tricky.

Mit freundlichen Grüßen

Timo Klecker

Von: Rajan, Pavithra [mailto:RAJANP(at)coned(dot)com]
Gesendet: Freitag, 26. März 2010 15:17
An: Timo Klecker; pgsql-general(at)postgresql(dot)org
Betreff: RE: [GENERAL] 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.