<p><font face="Arial" size="2">hello list, </font><br /><font face="Arial" size="2">i have some problems with an
sql-statementwhich runs on oracle but not on postgresql (i want update only if result of SELECT is not empty, the
SELECT-queriesare identical):</font><p><font face="Arial" size="2">UPDATE table1 t1<br /> SET (t1.id) =<br />
(SELECT h.id FROM table2 t2,table3 t3, table1 t1<br /> WHERE t3.field = t2.field<br />
AND t2.id = t1.id<br /> AND t1.id <> t3.id)<br /> WHERE<br
/> (SELECT h.id FROM table2 t2,table3 t3, table1 t1<br /> WHERE t3.field =
t2.field<br/> AND t2.id = t1.id<br /> AND t1.id
<>t3.id) IS NOT NULL; </font><br /><br /><p><font face="Arial" size="2">thanks, hans </font><br /><br />