DELETE ... USING ... - 8.0 and 8.1 compatibility problem

Поиск
Список
Период
Сортировка
От Miroslav Šulc
Тема DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Дата
Msg-id 447E0BF3.2040707@startnet.cz
обсуждение исходный текст
Ответы Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
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


Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: hi i need to encrypt one field in a table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem