preference-procs-postgresql.xql

DB Query file

Related Files

• packages/user-preferences/tcl/preference-procs.xql
• packages/user-preferences/tcl/preference-procs.tcl
• packages/user-preferences/tcl/preference-procs-postgresql.xql
• packages/user-preferences/tcl/preference-procs-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="preference::set_package_default.set_package_default">
<querytext>
select user_pref_type__set_package_default(
       :preference_type_id,
       :package_id,
       :default_value
);
</querytext>
</fullquery>

<fullquery name="preference::set_user_pref.set_user_pref">
<querytext>
select user_pref_type__set_user_pref(
        :preference_type,
        :package_id,
        :user_id,
        :value
);
</querytext>
</fullquery>

<fullquery name="preference::get_user_pref.get_user_pref">
<querytext>
select user_pref_type__get_user_pref (
           :preference_type,
           :package_id,
           :user_id
      );
</querytext>
</fullquery>
 
</queryset>