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

pgsql-server: Update DELETE FROM: < * Allow DELETE to handle table

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: Update DELETE FROM: < * Allow DELETE to handle table
Date: 2004-08-10 17:30:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Log Message:

< * Allow DELETE to handle table aliases for self-joins
> * Allow an alias to be provided for the target table in UPDATE/DELETE
<   There is no way to create a table alias for the deleted table for use
<   in the DELETE WHERE clause.  The agreed approach is to allow a USING 
<   clause to specify additional tables.  UPDATE already has an optional 
<   FROM clause for this purpose.
>   This is not SQL-spec but many DBMSs allow it.
> * Allow additional tables to be specified in DELETE for joins
>   UPDATE already allows this (UPDATE...FROM) but we need similar
>   functionality in DELETE.  It's been agreed that the keyword should 
>   be USING, to avoid anything as confusing as DELETE FROM a FROM b.

Modified Files:
        TODO (r1.1325 -> r1.1326)

pgsql-committers by date

Next:From: Peter EisentrautDate: 2004-08-10 18:32:25
Subject: pgsql-server: Translation update
Previous:From: Bruce MomjianDate: 2004-08-10 16:29:45
Subject: pgsql-server: Update DELETE FROM TODO info.

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