Re: [SQL] Tweak sql result set... ?

(anonymous) wrote: > I have a problem where I want to tweak a simple select in an > "unobtrusive way". Imagine I have the following select statement: > "SELECT name FROM customer LIMIT 1" and I get a normal result set from > this. But, could I,maybe by defining some other function or similar, > ch

[SQL] Tweak sql result set... ?

I have a problem where I want to tweak a simple select in an "unobtrusive way". Imagine I have the following select statement: "SELECT name FROM customer LIMIT 1" and I get a normal result set from this. But, could I,maybe by defining some other function or similar, change the result set *without*

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, 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

Re: [SQL] Detect referential integrity structure

Perhaps another option: Alter the references to ON DELETE CASCADE as seen here Akos Gabriel wrote: Hi, I've a big/complex database (Adempiere - www.adempiere.org ) where I'd like to delete some rows from some tables (delete a

[SQL] Detect referential integrity structure

Hi, I've a big/complex database (Adempiere - www.adempiere.org ) where I'd like to delete some rows from some tables (delete a client and its data from the ERP database). All tables are in one schema (adempiere). There are some foreign keys/constraints. I've following options: - disable all const

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

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) =

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

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