Annotation: core.get_account_view_by_account_master_id

CREATE OR REPLACE FUNCTION core.get_account_view_by_account_master_id(_account_master_id integer, _row_number integer)
RETURNS TABLE(id bigint, account_id bigint, account_name text)

Information: core.get_account_view_by_account_master_id

Schema	core
Function Name	get_account_view_by_account_master_id
Arguments	_account_master_id integer, _row_number integer
Owner	postgres
Result Type	TABLE(id bigint, account_id bigint, account_name text)
Description

Implementation: core.get_account_view_by_account_master_id

CREATE OR REPLACE FUNCTION core.get_account_view_by_account_master_id(_account_master_id integer, _row_number integer)
 RETURNS TABLE(id bigint, account_id bigint, account_name text)
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN QUERY
    SELECT ROW_NUMBER() OVER (ORDER BY accounts.account_id) +_row_number, * FROM 
    (
        SELECT core.accounts.account_id, core.get_account_name_by_account_id(core.accounts.account_id)
        FROM core.accounts
        WHERE core.accounts.account_master_id = _account_master_id
    ) AS accounts;    
END;
$function$