The following bug has been logged online: Bug reference: 4295 Logged by: Fred Perniss Email address: [EMAIL PROTECTED] PostgreSQL version: all Versions Operating system: Open SuSe Linux 11 Description: DELETE WHERE Condition Details:
Fist: Sorry for my bad english. I have 2 tables table t1 with fields t1.t1_id, t1.t1_value table t2 with fields t2.t2_id, t2.t2_t1_id, t2.t2_value table t2 have a forign key to table t1 (t2_t1_id) I have to delete all rows from table t2 with the condition t1.t1_value = 5. In Postgres the switch add_mising_from=on the SQL-Command DELETE FROM t2 WHERE (t2.t2_t1_id=t1.t1_id) AND t1.t1_inhalt=5 ; works (with message in Log). If the switch add_missing_from=off following Error-Message will be promted: Fehlender Eintrag in FROM Klausel für Tabelle t1 The new Syntax from SQL in MySQL Version 4 DELETE FROM T2 FROM t1, t2 WHERE (t2.t2_t1_id=t1.t1_id) AND t1.t1_inhalt=5 ; is not implemented. I don't find any other Syntax for this and I don't find any in the log, how I can change the sytax or how postgre do this if the switch add_mising_from is on. Can you tell me the correct syntax or can you tell me how the server transform the query if the switch is set to on? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
