From: | juniorfreire <juniorfreire(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | function create error |
Date: | 2013-03-14 14:52:43 |
Message-ID: | 1363272763007-5748466.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
--
-- 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2013-03-14 15:13:30 | Re: function create error |
Previous Message | Dave Page | 2013-03-14 13:48:31 | Re: No smallserial data type in version 1.16.1 |