Skip site navigation (1) Skip section navigation (2)

DELETE ... USING

From: Neil Conway <neilc(at)samurai(dot)com>
To: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Cc: eulerto(at)yahoo(dot)com(dot)br
Subject: DELETE ... USING
Date: 2005-04-04 10:16:00
Message-ID: 425113E0.20900@samurai.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
This patch is a cleaned up version of Euler Taveira de Oliveira's patch 
implementing DELETE ... USING. I removed a bunch of unused code (no need 
to tlist transformations), updated copyfuncs/equalfuncs, improved the 
documentation, rearranged a few things, and added regression tests. I 
haven't done psql tab completion. Barring any objections, I'll apply 
this to HEAD tomorrow.

On a related note, UPDATE uses the FROM keyword to denote the list of 
relations to join with, whereas DELETE uses USING. Should we make USING 
an alias for FROM in UPDATE and if so, should we deprecate FROM? This 
would be more consistent, which I suppose is a good thing.

-Neil

Attachment: delete_using-5.patch
Description: text/x-patch (14.8 KB)

Responses

pgsql-hackers by date

Next:From: Jim ButtafuocoDate: 2005-04-04 13:32:45
Subject: Re: BuildFarm status: recent check failures
Previous:From: Neil ConwayDate: 2005-04-04 10:09:49
Subject: Re: add_missing_from in 8.1

pgsql-patches by date

Next:From: Neil ConwayDate: 2005-04-04 11:19:24
Subject: avg(int2) and avg(int8) micro-opt
Previous:From: Peter EisentrautDate: 2005-04-04 08:22:27
Subject: Re: pgsql: Adjust SGML ulink tags to the URL is always displayed in our

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group