Re: Funcion retorna SETOF RECORD

On Tue, Aug 12, 2008 at 11:27 AM, Raul Andres Duque
<ra_duque(at)yahoo(dot)com(dot)mx> wrote:
> Envio ejemplo:
>
> CREATE OR REPLACE FUNCTION csp_SaldoInicial(fecha date, filtro character
> varying)
> RETURNS SETOF RECORD AS
> $BODY$
> DECLARE
> registros RECORD;
> strQuery VARCHAR := '';
> BEGIN
> RETURN QUERY SELECT id_parte::int AS id_parte FROM def_salinvmes;
> RETURN;
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE
>
> select * from csp_SaldoInicial(now()::date, '1=1');
>
>

CREATE OR REPLACE FUNCTION csp_SaldoInicial(fecha date, filtro
character varying)
RETURNS SETOF RECORD AS
$BODY$
DECLARE
registros RECORD;
strQuery VARCHAR := '';
BEGIN
RETURN QUERY SELECT id_parte FROM def_salinvmes;
RETURN;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE

select * from csp_SaldoInicial(now()::date, '1=1') as (id_parte int);

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157