[SQL] DELETE ... USING ... - 8.0 and 8.1 compatibility problem

2006-05-31 Thread Miroslav Ć ulc
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 = MRTPQuot

Re: [SQL] DELETE ... USING ... - 8.0 and 8.1 compatibility problem

2006-05-31 Thread Tom Lane
=?ISO-8859-2?Q?Miroslav_=A9ulc?= <[EMAIL PROTECTED]> writes: > 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