How to find the max value in a select? - Mailing list pgsql-general

I need to do something like this:

SELECT ...
FROM ...
WHERE ...
ORDER BY ...
COUNT 1

In other words, I want to find the one row matched by my WHERE clause
which is the maximum or minimum of all the rows that matched it.  I
could do the query above (ORDER BY...   COUNT 1), but does Postgres
optimize this, or does it find all the rows, sort them, and then take
off the top one?  Or is there some better way to do it?

Thanks,

e