Annotation: core.get_menu_id

Information: core.get_menu_id

Implementation: core.get_menu_id

CREATE OR REPLACE FUNCTION core.get_menu_id(menu_code text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT core.menus.menu_id
        FROM core.menus
        WHERE core.menus.menu_code=$1
    );
END
$function$