Re: WG: [SQL] sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL

Hello again, Le 29/07/09 12:21, nha a écrit : > Hello, > > Le 29/07/09 11:48, Gau, Hans-Jürgen a écrit : >> Sorry, it's a lapse by copying and simplification the original version. that >> is correct: >> >> UPDATE table1 t1 >> SET (t1.id) = >> (SELECT t3.id FROM table2 t2,table

Re: WG: [SQL] sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL

Hello, Le 29/07/09 11:48, Gau, Hans-Jürgen a écrit : > Sorry, it's a lapse by copying and simplification the original version. that > is correct: > > UPDATE table1 t1 > SET (t1.id) = > (SELECT t3.id FROM table2 t2,table3 t3, table1 t1 > WHERE t3.field = t2.fie

WG: [SQL] sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL

Sorry, it's a lapse by copying and simplification the original version. that is correct: UPDATE table1 t1 SET (t1.id) = (SELECT t3.id FROM table2 t2,table3 t3, table1 t1 WHERE t3.field = t2.field AND t2.id = t1.id