Postgres Pro
Downloads
Home   >   mailing lists

Re: delete with self join - Mailing list pgsql-general

From Richard Huxton
Subject Re: delete with self join
Date
Msg-id 46248378.8010702@archonet.com
Whole thread Raw
In response to delete with self join  (garry saddington <garry@schoolteachers.co.uk>)
Responses Re: delete with self join  (garry saddington <garry@schoolteachers.co.uk>)
List pgsql-general
Tree view 
garry saddington wrote:
> 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?

1. What's happening - are you getting an error?

2. What is the query supposed to do? I can't see why you're not just doing:
DELETE FROM siblings WHERE sibling=175;

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PITR - "Rewind to snapshot" scheme
Next
From: garry saddington
Date:
Subject: Re: delete with self join