podoc:is_user_my_client_sql_function
Database Function Description of "is_user_my_client"
Name
is_user_my_client
Description
Checks if a particular user is a client of another user.
Purpose
To retrieve the client status of a particular user with another user.
Schema
CREATE FUNCTION is_user_my_client(INTEGER, INTEGER) RETURNS BIGINT AS 'select count(identifier) from client where client.users = $1 and client.client = $2 and status=2' LANGUAGE 'sql';
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE FUNCTION is_user_my_client(INTEGER, INTEGER) RETURNS BIGINT AS 'select count(identifier) from client where client.users = $1 and client.client = $2 and status=2' LANGUAGE 'sql';
podoc/is_user_my_client_sql_function.txt · Last modified: 2007/04/23 14:30 by Luud