Forum OpenACS Q&A: Response to Porting Oracle's ROWNUM

Collapse
Posted by Dan Wickstrom on
pg doesn't support subselects in from clauses, and it probably won't support it until they do the query-tree rewrite which is slated to happen for pg version 7.2.

Your modified query looks fine.