On Tue, Aug 12, 2008 at 11:27 AM, Raul Andres Duque <[EMAIL PROTECTED]> 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 -- TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda
