Re: [HACKERS] ORDER BY

[Marc G. Fournier]

On Mon, 25 Jul 2005, Jeffrey W. Baker wrote:

On Mon, 2005-07-25 at 18:11 -0300, Marc G. Fournier wrote:
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;

Seems like it should work.  Is it not returning in fullname order in
your tests?

Full name isn't a field in the results, so how would it be ORDERing based 
on it?  fullname is a field in the table being joined in order to restrict 
the results to just those with cs.detail = 'test' ... but company itself 
doesn't have a field fullname ...


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend