Annotation: core.get_state_id_by_state_name

CREATE OR REPLACE FUNCTION core.get_state_id_by_state_name(text)
RETURNS integer

Information: core.get_state_id_by_state_name

Schema	core
Function Name	get_state_id_by_state_name
Arguments	text
Owner	postgres
Result Type	integer
Description

Implementation: core.get_state_id_by_state_name

CREATE OR REPLACE FUNCTION core.get_state_id_by_state_name(text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN state_id
    FROM core.states
    WHERE state_name = $1;
END
$function$