Search Postgresql Archives

delete with self join

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: delete with self join
From: garry saddington <garry@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 16 Apr 2007 21:33:45 +0100

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: delete with self join
  - From: Richard Huxton
- Re: delete with self join
  - From: Richard Broersma Jr

Prev by Date: Dynamic DDL
Next by Date: Re: Dynamic DDL
Previous by thread: Dynamic DDL
Next by thread: Re: delete with self join
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux