sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL

Поиск
Список
Период
Сортировка
От Gau, Hans-Jürgen
Тема sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL
Дата
Msg-id 670F563845D6B34189933C9C7322B4872C0568@LV-MX-00002-V02.LV.ads.niedersachsen.de
обсуждение исходный текст
Ответы Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL
Список pgsql-sql
Дерево обсуждения 
<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 />

В списке pgsql-sql по дате отправления: