--
-- Name: fc_mesextenso(integer, character varying); Type: FUNCTION; Schema:
public; Owner: sigmasol
--
CREATE FUNCTION public.fc_mesextenso(integer, character varying) RETURNS
text LANGUAGE plpgsql AS $_$
declare iMes alias for $1; sTipoRetorno alias for $2; sNomeMes text; sSiglaMes text;
begin select nome, sigla into sNomeMes, sSiglaMes from (values (1::integer, 'Janeiro'::text, 'Jan'::text),
(2::integer, 'Fevereiro'::text, 'Fev'::text), (3::integer, 'Março'::text, 'Mar'::text),
(4::integer, 'Abril'::text, 'Abr'::text), (5::integer, 'Maio'::text, 'Mai'::text),
(6::integer, 'Junho'::text, 'Jun'::text), (7::integer, 'Julho'::text, 'Jul'::text),
(8::integer,'Agosto'::text, 'Ago'::text), (9::integer, 'Setembro'::text, 'Set'::text),
(10::integer,'Outubro'::text, 'Out'::text), (11::integer, 'Novembro'::text, 'Nov'::text),
(12::integer,'Dezembro'::text, 'Dez'::text)) as meses(mes,
nome, sigla) where mes = iMes;
if sTipoRetorno = 'nome' then return sNomeMes; else return sSiglaMes; end if;
end;
$_$;
ALTER FUNCTION public.fc_mesextenso(integer, character varying) OWNER TO
sigmasol;
--
View this message in context: http://postgresql.1045698.n5.nabble.com/function-create-error-tp5748466.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.