Postgres Pro
Downloads
Home   >   mailing lists

delete with self join - Mailing list pgsql-general

From garry saddington
Subject delete with self join
Date
Msg-id 1176755625.7783.1.camel@localhost
Whole thread Raw
Responses Re: delete with self join  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: delete with self join  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
I am trying this syntax which is my interpretation of the docs:

     delete from siblings s1 using siblings s2
        WHERE  s1.principal = s2.principal
              and s1.sibling=175

Can anyone tell me where I am going wrong?
regards
Garry

pgsql-general by date:

Previous
From: "Ketema"
Date:
Subject: Dynamic DDL
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Dynamic DDL