Annotation: office.get_login_id

CREATE OR REPLACE FUNCTION office.get_login_id(_user_id integer)
RETURNS bigint

Information: office.get_login_id

Schema	office
Function Name	get_login_id
Arguments	_user_id integer
Owner	postgres
Result Type	bigint
Description

Implementation: office.get_login_id

CREATE OR REPLACE FUNCTION office.get_login_id(_user_id integer)
 RETURNS bigint
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT login_id
        FROM audit.logins
        WHERE user_id=$1
        AND login_date_time = 
        (
            SELECT MAX(login_date_time)
            FROM audit.logins
            WHERE user_id=$1
        )
        LIMIT 1
    );
END
$function$