Re: en que estoy fallando (sintaxis de funcion)

On 2/2/07, jeferson alvarez <jalvarez(at)renova(dot)com(dot)pe> wrote:
> CREATE OR REPLACE FUNCTION sgc_m_doc_base_buscar(tipo bpchar)
> RETURNS SETOF refcursor AS '
> DECLARE
> BEGIN
> IF $1=''NEN'' THEN
> OPEN nota FOR SELECT * FROM alma_m_nota_ing;

no has declarado nota

> RETURN NEXT;

return next que?

> ELSE
> OPEN notasal FOR SELECT * FROM alm_m_nota_salida;

no has declarado notasal

> RETURN NEXT;

return next que?

> END IF;
> RETURN;
> END;
> '
> LANGUAGE 'plpgsql' VOLATILE;
>
>

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook