> 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
