delete with self join

From: garry saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: delete with self join
Date: 2007-04-16 20:33:45
Message-ID: 1176755625.7783.1.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ketema 2007-04-16 20:37:43 Dynamic DDL
Previous Message Tom Lane 2007-04-16 19:38:54 Re: concatenating setof functions