> 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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
