Re: Hey! ORDER BY in VIEWS?

> But - this gives them in reverse timestamp order. So - wrap the query in
> a view and then apply your own ORDER BY.
> 
> Can't remember who came up with this (some evil genius :-) - but it
> seemed to make sense so I stuck the example in my PostgreSQL notes.

We kept rejecting the idea of ORDER BY in a view until someone suggested
LIMIT and ORDER BY, at which point we had to enable it.  I think Tom did
the work.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026