is_user_my_client

Checks if a particular user is a client of another user.

To retrieve the client status of a particular user with another user.

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

• client

Version 2.5

Still in use

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