Index: openacs-4/packages/edit-this-page/www/etp-swap-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/Attic/etp-swap-postgresql.xql,v diff -u -N --- openacs-4/packages/edit-this-page/www/etp-swap-postgresql.xql 3 Dec 2001 18:33:37 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,32 +0,0 @@ - - - postgresql7.1 - - - - 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 - - - - - - select tree_sortkey, item_id - from cr_items - where tree_sortkey >= :prev_sort_key - order by tree_sortkey - - - - - - update cr_items - set tree_sortkey = :new_sortkey - where item_id = :item_id - - - -