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:raj...@coned.com] Gesendet: Freitag, 26. März 2010 15:17 An: Timo Klecker; pgsql-general@postgresql.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:klec...@decoit.de] Sent: Friday, March 26, 2010 10:12 AM To: Rajan, Pavithra ; pgsql-general@postgresql.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-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von Rajan, Pavithra Gesendet: Freitag, 26. März 2010 14:48 An: pgsql-general@postgresql.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.
