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@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Rajan,
Pavithra
Gesendet: Freitag, 26. März 2010 14:48
An: pgsql-general@xxxxxxxxxxxxxx
Betreff: 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.