Sebastian> Thanks for all answers so far. I'm just sweating over
Sebastian> CONNECT BY constructs. Somewhere in openACS code I
Sebastian> spotted a solution which uses two (or three?) Pl/PgSql
Sebastian> functions emulating LEVEL and ROWNUM, or something like
Sebastian> that. Is this preferred way?
We've done some connect by and oracle pseudo-column emulation with
recursive functions for pg. See the intranet, homepage and file-storage modules for examples. This is not optimal, but it could be improved by caching the order by field in a table column. Other
alternatives have also been suggested.
See this previous discussion
