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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Date: 2006-05-31 21:50:19
Message-ID: 22509.1149112219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?ISO-8859-2?Q?Miroslav_=A9ulc?= <miroslav(dot)sulc(at)startnet(dot)cz> 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 works in both versions but the slowdown is not acceptable.

Set add_missing_from TRUE ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Clarke 2006-06-01 11:05:54 Table design question
Previous Message Miroslav Šulc 2006-05-31 21:34:43 DELETE ... USING ... - 8.0 and 8.1 compatibility problem