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$