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

Reply via email to