Postgres Pro
Downloads
Home   >   mailing lists

Re: delete query using CTE - Mailing list pgsql-general

From Michael Lewis
Subject Re: delete query using CTE
Date
Msg-id CAHOFxGqTfxoSJiyH2aHYrA6GcZ45p5fedPqXEKv4HOcrEohz3g@mail.gmail.com
Whole thread Raw
In response to delete query using CTE  (Roger Bos <roger.bos@gmail.com>)
List pgsql-general
Tree view
You can't delete rows that are in a CTE. You want to delete rows that are in the table. Do you have a primary key that you can reference? Else, you may need to reference the system column ctid.

pgsql-general by date:

Previous
From: Roger Bos
Date:
Subject: delete query using CTE
Next
From: "David G. Johnston"
Date:
Subject: Re: delete query using CTE