Is there any option that one might set to have PostgreSQL emit a NOTICE when it encounters a SELECT statement having a table not involved in any join condition? For example, if I do: SELECT employees.name FROM employees, salaries; It would aide debugging application development a bit if there was a way to have PostgreSQL emit a NOTICE like: NOTICE: Cartesian product generated for table 'salaries' in the same manner that it now adds a notice for missing FROM clause entries. I realize that there are queries like the above where the results are as expected, which is why it would be nice for it to be some option. The above is obvious, but some of my queries contain joins with > 15 tables. In development, when some of the tables are empty or only contain 1 record, the results may appear to work. Only until later would I discover a missing join condition when more then 1 row is added. Just a thought, Mike Mascari [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html