From: Luiz Rafael Culik Guimaraes <culikr@brturbo.com>
Cc: pgsql-sql@postgresql.org
Subject: number os commands inside transaction block
Date: Mon, 31 Jan 2005 19:54:45 -0200
Message-ID: <043f01c507df$9174a790$0105a8c0@luiz> (raw)
References: <6c21003b0501301141234c256b@mail.gmail.com>
<20050131132701.G12960@megazone.bigpanda.com>
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" <sszabo@megazone.bigpanda.com>
To: "Don Drake" <dondrake@gmail.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: culikr@brturbo.com
Subject: Re: number os commands inside transaction block
In-Reply-To: <043f01c507df$9174a790$0105a8c0@luiz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox