Just curious as to whether or not a warning or something should be issued in a case like:
SELECT c.* FROM company c, company_summary cs WHERE c.id = cs.id AND cs.detail = 'test' ORDER BY cs.fullname;Unless I'm missing something, the ORDER BY clause has no effect, but an EXPLAIN shows it does take extra time, obviously ...
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org