Annotation: core.get_state_name_by_state_id

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

Information: core.get_state_name_by_state_id

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

Implementation: core.get_state_name_by_state_id

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