choose-message-move-postgresql.xql

DB Query file

Related Files

[ 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_tree_sortkey">
        <querytext>
            select substring(tree_sortkey, 0, 9) as father_tree_sortkey 
	    from forums_messages 
	    where message_id=$message(message_id)

        </querytext>
    </fullquery>
    

    <fullquery name="get_parent_id">
        <querytext>
            select parent_id
            from forums_messages
            where forum_id = $message(forum_id) and tree_sortkey between tree_left('$father_tree_sortkey') and tree_right('$father_tree_sortkey') 
	    order by tree_sortkey desc

        </querytext>
    </fullquery>

</queryset>