Re: DELETE syntax on JOINS

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE syntax on JOINS
Date: 2009-08-24 17:52:11
Message-ID: 20090824175211.GK5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 24, 2009 at 01:41:28PM -0400, Tom Lane wrote:
> The real problem with this is that all the
> good candidates for the reserved word are things people are probably
> already using as aliases, so we'd have a large risk of breaking existing
> queries. We could avoid that with a sufficiently ugly choice like
>
> DELETE FROM target t USING DELETE_TARGET LEFT JOIN other_table ot ON ...
>
> but yech ...

PRIMARY or TABLE?

Both are pretty grim, but I think they're reserved at the moment.

--
Sam http://samason.me.uk/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2009-08-24 17:52:59 Re: Slaying the HYPOTamus
Previous Message Andrew Dunstan 2009-08-24 17:50:07 Re: hba load error and silent mode