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

Collapse
4: Response to Porting Oracle's ROWNUM (response to 1)
Posted by Dan Wickstrom on 08/31/00 08:08 PM
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.