Обсуждение: function create error

Поиск
Список
Период
Сортировка

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.

Re: function create error

От
Raymond O'Donnell
Дата:
On 14/03/2013 14:52, juniorfreire wrote:
> --
> -- 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;
> 

What is your question?

Ray.



-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie