User Tools

Site Tools


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

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