delete with self join

Поиск
Список
Период
Сортировка
Искать
От
garry saddington
Тема
delete with self join
Дата
Msg-id
1176755625.7783.1.camel@localhost
Список
Дерево обсуждения
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>
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

В списке pgsql-general по дате отправления
От: Ketema
Дата:
Сообщение: Dynamic DDL
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Dynamic DDL
FAQ