On Jul 28, 2009, at 5:10 PM, nha wrote:
Hello,
Le 28/07/09 14:25, Daryl Richter a écrit :
On Jul 28, 2009, at 5:58 AM, Gau, Hans-Jürgen wrote:
hello list,
i have some problems with an sql-statement which runs on oracle but
not on postgresql (i want update only if result of SELECT is not
emp
Hello,
Le 28/07/09 14:25, Daryl Richter a écrit :
>
> On Jul 28, 2009, at 5:58 AM, Gau, Hans-Jürgen wrote:
>
>> hello list,
>> i have some problems with an sql-statement which runs on oracle but
>> not on postgresql (i want update only if result of SELECT is not
>> empty, the SELECT-queries are
On Jul 28, 2009, at 5:58 AM, Gau, Hans-Jürgen wrote:
hello list,
i have some problems with an sql-statement which runs on oracle but
not on postgresql (i want update only if result of SELECT is not
empty, the SELECT-queries are identical):
UPDATE table1 t1
SET (t1.id) =
