function letras

-- FUNCTION: public.letras()

-- DROP FUNCTION IF EXISTS public.letras();

CREATE OR REPLACE FUNCTION public.letras(
    )
    RETURNS TABLE(codigo integer)
    LANGUAGE 'plpgsql'
    COST 50
    VOLATILE LEAKPROOF PARALLEL UNSAFE
    ROWS 1000

AS $BODY$
BEGIN
    RETURN QUERY
    (
        WITH
            minusculas AS
            (
                SELECT cod FROM generate_series(97, 122, 1) cod ORDER BY random() * 25
            ),
            maiusculas AS
            (
                SELECT cod FROM generate_series(65,90, 1) cod ORDER BY random() * 25
            )
        SELECT cod FROM maiusculas UNION ALL SELECT cod FROM minusculas
    );
END;
$BODY$;

ALTER FUNCTION public.letras()
    OWNER TO postgres;