get_user_pref

CREATE OR REPLACE FUNCTION get_user_pref(int, text) RETURNS text AS '
  SELECT value
           FROM user_preferences
          WHERE owner = $1 
            AND key = $2;
' LANGUAGE 'sql';

Version 2.34

Still in use

= Version 2.34 =

CREATE OR REPLACE FUNCTION get_user_pref(int, text) RETURNS text AS '
  SELECT value
           FROM user_preferences
          WHERE owner = $1 
            AND key = $2;
' LANGUAGE 'sql';