Re: Delete from Join

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 not standard but
that is fine as I am doing a subst. MS actually allows:

DELETE from table from table.....

I change the second from to a using and it works fine most of the time.

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;
 


Where the INNER JOIN keyword is used in the delete.

In the do***entation section you cited, they refer to the from clause
in the usinglist. The from clause link there refers to select which 
states
that a join keyword is valid in a from clause.

What I have found is it sometimes compiles but doesn't work.

I am just seeking verification  if it is supposed to work.

Gwyneth

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general