Re: delete with self join
От
Richard Huxton
Тема
Re: delete with self join
Дата
Msg-id
46248378.8010702@archonet.com
Ответ на
delete with self join (garry saddington)
Список
Дерево обсуждения
delete with self join garry saddington <garry@schoolteachers.co.uk>
Re: delete with self join Richard Huxton <dev@archonet.com>
Re: delete with self join garry saddington <garry@schoolteachers.co.uk>
Re: delete with self join Richard Huxton <dev@archonet.com>
Re: delete with self join garry saddington <garry@schoolteachers.co.uk>
Re: delete with self join Thomas Burdairon <tburdairon@entelience.com>
Re: delete with self join Richard Broersma Jr <rabroersma@yahoo.com>
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 по дате отправления
