Many thanks to Gaetano Mendola and Tom Lane for the hints about using
fields from other tables in a DELETE's WHERE clause.  That was the magic
bullet I needed, and my application is working as expected.

--- Steve

Steven Rosenstein
IT Architect/Developer | IBM Virtual Server Administration
Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001
Text Messaging: 6463456978 @
Email: srosenst @

"Learn from the mistakes of others because you can't live long enough to
make them all yourself." -- Eleanor Roosevelt

             Tom Lane                                                      
             <[EMAIL PROTECTED]                                             
             s>                                                         To 
             Sent by:                  Steven Rosenstein/New               
             pgsql-performance         York/[EMAIL PROTECTED]                   
             [EMAIL PROTECTED]                                          cc 
                                       Re: [PERFORM] Are JOINs allowed     
             02/06/2005 02:49          with DELETE FROM                    

Steven Rosenstein <[EMAIL PROTECTED]> writes:
> Thank you for the link to the documentation page.  I forgot to mention
> we're still using version 7.3.  When I checked the 7.3 documentation for
> DELETE, there was no mention of being able to use fields from different
> tables in a WHERE clause.  This feature must have been added in a
> subsequent release of PostgreSQL.

No, it's been there all along, if perhaps not well documented.

                                     regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to