Annotation: office.get_store_id_by_store_name

CREATE OR REPLACE FUNCTION office.get_store_id_by_store_name(text)
RETURNS integer

Information: office.get_store_id_by_store_name

Schema	office
Function Name	get_store_id_by_store_name
Arguments	text
Owner	postgres
Result Type	integer
Description

Implementation: office.get_store_id_by_store_name

CREATE OR REPLACE FUNCTION office.get_store_id_by_store_name(text)
 RETURNS integer
 LANGUAGE plpgsql
 STABLE
AS $function$
BEGIN
    RETURN
    (
        SELECT store_id
        FROM office.stores
        WHERE store_name=$1
    );
END
$function$