Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 16 Apr 2007 21:33:45 +0100
- Message-id: <1176755625(dot)7783(dot)1(dot)camel(at)localhost>
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
- Follow-Ups:
- Re: delete with self join
- From: Richard Huxton
- Re: delete with self join
- From: Richard Broersma Jr
- Re: delete with self join
- Prev by Date: Dynamic DDL
- Next by Date: Re: Dynamic DDL
- Previous by thread: Dynamic DDL
- Next by thread: Re: delete with self join
- Indexes: