Dear Friends
how i can increse the number of commands in an transaction block
i use postgres 7.4.5 on linux
Regards
Luiz
----- Original Message ----- From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Don Drake" <[EMAIL PROTECTED]>
Cc: <pgsql-sql@postgresql.org>
Sent: Monday, January 31, 2005 7:31 PM
Subject: Re: [SQL] plpgsql functions and NULLs
On Sun, 30 Jan 2005, Don Drake wrote:
OK, I have a function that finds records that changed in a set of tables and attempts to insert them into a data warehouse.
There's a large outer loop of candidate rows and I inspect them to see if the values really changed before inserting.
My problem is that when I look to see if the row exists in the warehouse already, based on some IDs, it fails when an ID is NULL. The ID is nullable, so that's not a problem.
But I'm forced to write an IF statement looking for the potential NULL and write 2 queries:
IF omcr_id is null select * from .... WHERE omcr_id is NULL AND ... ELSE select * from .... WHERE omcr_id=candidate.omcr_id AND .... END IF;
Hmm, perhaps some form like:
WHERE not(candidate.omcr_id is distinct from omcr_id)
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.2 - Release Date: 28/1/2005
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
