[pgadmin-support] function create error

[juniorfreire]

--
-- 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.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support