Tom Lane wrote:
Gwyneth Morrison <[EMAIL PROTECTED]> writes:
What I am actually trying to get past is:
DELETE FROM data_table1
using data_table2 INNER JOIN
data_table1 ON data_table1.fkey =
data_table2.pkey;
Gwyneth Morrison <[EMAIL PROTECTED]> writes:
> What I am actually trying to get past is:
> DELETE FROM data_table1
> using data_table2 INNER JOIN
> data_table1 ON data_table1.fkey =
> data_table2.pkey;
The equivalent to that in Postgres would be
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote:
> From: Gwyneth Morrison <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 7:12 PM
> --- On Wed, 7/2/08, Gwyneth Morrison
Scott Marlowe wrote:
Take a look here, in the notes section:
http://www.postgresql.org/docs/8.3/interactive/sql-delete.html
on the using keyword.
Thank you for your reply Scott,
I guess this is where the confusion started for me.
It says here in your reference that the using clause is n
Take a look here, in the notes section:
http://www.postgresql.org/docs/8.3/interactive/sql-delete.html
on the using keyword.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote:
> From: Gwyneth Morrison <[EMAIL PROTECTED]>
> Subject: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 3:15 PM
> Hello,
>
> Is it possible
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote:
> From: Gwyneth Morrison <[EMAIL PROTECTED]>
> Subject: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 3:15 PM
> Hello,
>
> Is it possible
Hello,
Is it possible to use a join keyword in a delete?
For example:
DELETE FROM data_table1
using data_table2 INNER JOIN
data_table1 ON data_table1.fkey = data_table2.pkey;
It is not directly mentioned in the delete syntax but the delete refers
to