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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
