Forum .LRN Q&A: Temporary fix for breakage in moving portlets up/down during portal layout customization (postgres)

In /packages/new-portal/tcl/portal-procs.xql, the queries
swap_element.get_prev_sort_key and swap_element.get_next_sort_key are
both Oracle specific.

They should both be 1) moved to portal-procs-oracle.xql then create
corresponding entries in portal-procs-postgresql.xql.  2) add aliases
to the subselects (just add "as inner_select" after the closing
parentheses)3) change "where rownum=1" to "limit 1"