Thanks very much :-) this saves lot of time for my update statements .... -Venkatesh --- Alban Hertroys <alban@xxxxxxxxxxxxxxxxx> wrote: > Venkatesh Babu wrote: > > Hello, > > > > I need to update few rows of a table (call it 't') > and > > need to set just one column col1 (out of around > 100 > > columns... to be exact, our table has 116 > columns). > > The info about rows to be updated is present in > > another table t2. t2 just contains 2 columns > (row_key, > > new value for col1). > > > > What is the best way to perform update? Can't I > give > > an update statement like: UPDATE t set > > col1=t2.new_col1_val where t1.row_key = t2.row_key > > ???? I think this kind of support is provided in > db2, > > but couldn't find how this can be done in > postgres. > > You're close: > > UPDATE t1 > SET col1 = t2.new_col1 > FROM t2 > WHERE t1.row_key = t2.row_key; > > -- > Alban Hertroys > MAG Productions > > T: +31(0)53 4346874 > F: +31(0)53 4346876 > E: alban@xxxxxxxxxxxxxxxxx > W: http://www.magproductions.nl > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
