CREATE OR REPLACE FUNCTION core.get_industry_id_by_party_id(_party_id bigint) RETURNS integer LANGUAGE plpgsql AS $function$ BEGIN RETURN industry_id FROM core.parties WHERE party_id=$1; END $function$