DO NOT REPLY [Bug 41181] - Problem in Postgres query

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41181>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41181





------- Additional Comments From [email protected]  2007-02-25 19:15 -------
The current syntax is correct. This is a non-standard syntax in PostgreSQL 
SQL. As explained in the PostgreSQL documentation:

Notes

PostgreSQL lets you reference columns of other tables in the WHERE condition. 
For example, to delete all films produced by a given producer, one might do

DELETE FROM films
  WHERE producer_id = producers.id AND producers.name = 'foo';

What is essentially happening here is a join between films and producers, with 
all successfully joined films rows being marked for deletion. This syntax is 
not standard. A more standard way to do it is

DELETE FROM films
  WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.