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 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
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
cht-
Von: nha [mailto:lyondi...@free.fr]
Gesendet: Dienstag, 28. Juli 2009 23:11
An: Gau, Hans-Jürgen
Cc: PgSQL-sql
Betreff: Re: [SQL] sql-porting-problem oracle to postgresql with UPDATE/IS
NOT NULL
Hello,
Le 28/07/09 14:25, Daryl Richter a écrit :
>
> On Jul 28, 2009, at 5:58 AM,
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) =
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) =
(SELECT h.id FROM table2 t2,table3 t3, table1 t1
