etp-swap-postgresql.xql
DB Query file
Related Files
- packages/edit-this-page/www/etp-swap.tcl
- packages/edit-this-page/www/etp-swap-postgresql.xql
- packages/edit-this-page/www/etp-swap-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="get_prev_key"> <querytext> select tree_sortkey, item_id from cr_items where parent_id = etp__get_folder_id(:package_id) and tree_sortkey < :sort_key order by tree_sortkey desc </querytext> </fullquery> <fullquery name="get_all_keys"> <querytext> select tree_sortkey, item_id from cr_items where tree_sortkey >= :prev_sort_key order by tree_sortkey </querytext> </fullquery> <fullquery name="update_key"> <querytext> update cr_items set tree_sortkey = :new_sortkey where item_id = :item_id </querytext> </fullquery> </queryset>