Annotation: core.get_party_id_by_party_code

CREATE OR REPLACE FUNCTION core.get_party_id_by_party_code(text)
RETURNS bigint

Information: core.get_party_id_by_party_code

Schema core
Function Name get_party_id_by_party_code
Arguments text
Owner postgres
Result Type bigint
Description

Implementation: core.get_party_id_by_party_code

CREATE OR REPLACE FUNCTION core.get_party_id_by_party_code(text)
 RETURNS bigint
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT
            party_id
        FROM
            core.parties
        WHERE 
            core.parties.party_code=$1
    );
END
$function$