From: Miroslav Šulc <miroslav.sulc@startnet.cz>
To: pgsql-sql@postgresql.org
Subject: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Date: Wed, 31 May 2006 23:34:43 +0200
Message-ID: <447E0BF3.2040707@startnet.cz> (raw)
Hello,
I have an SQL DELETE command that selects the items that should be
deleted against two large sets of data. This is the query:
DELETE FROM MRTPQuotaItem_MRTPContact
USING MRTPQuotaItem, MRTPQuota, MRTPContact
WHERE (MRTPQuotaItemId = MRTPQuotaItem.Id
AND MRTPQuotaItem.MRTPQuotaId = MRTPQuota.Id
AND MRTPQuota.MRTPWaveQuestionnaireId = 1)
AND (MRTPContactId = MRTPContact.Id
AND MRTPContact.MRTPWaveQuestionnaireId != 1)
The problem is that I have application deployed both on pg 8.0 and pg
8.1. This syntax (using USING) is only valid for 8.1+ and syntax without
USING is only valid for 8.0 and not for 8.1. I could write it using IN
operators which works in both versions but the slowdown is not acceptable.
Is there a way to write the command so that both versions of pg accept
it and not to use IN operator which unacceptably slows the thing down in
this case?
Thank you for any suggestion.
--
Miroslav Šulc
Attachments:miroslav.sulc.vcf (text/x-vcard, 347B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Schodov=C3=A1 309/10;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
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: miroslav.sulc@startnet.cz
Subject: Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
In-Reply-To: <447E0BF3.2040707@startnet.cz>
* 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