--fix CC 2021/06/28, !1018 #514
CREATE OR REPLACE FUNCTION magasin.get_numero_commande ()
 RETURNS bigint
 LANGUAGE SQL
AS $function$
 UPDATE magasin.numeros_sequence
    SET numero_sequence = numero_sequence + 1
  WHERE type_sequence = 'commande'
 RETURNING numero_sequence;
$function$;
