User Tools

Site Tools


podoc:get_user_pref_sql_function

Database Function Description of "get_user_pref"

Name

get_user_pref

Description

Purpose

Schema

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';

History

Used first

Version 2.34

Used last

Still in use

Change history

= 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';
podoc/get_user_pref_sql_function.txt · Last modified: 2007/10/19 11:24 by Luud