Annotation: core.get_email_address_by_party_id

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

Information: core.get_email_address_by_party_id

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

Implementation: core.get_email_address_by_party_id

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