Friday, September 26, 2008

Re: [pgsql-es-ayuda] Consulta plpgsql

estas poniendo asi:
EXECUTE 'SELECT count(SF.nro_base) as cantidadFamilia, SF.nro_base
FROM SocioFamiliar as SF
GROUP BY SF.nro_base'
INTO familiaresTemp;

poner asi

EXECUTE 'SELECT count(SF.nro_base) as cantidadFamilia, SF.nro_base
INTO TEMPORARY familiaresTemp
FROM SocioFamiliar as SF
GROUP BY SF.nro_base' ;

-
/*
## Emanuel CALVO FRANCO. ##
~-~- 3m4nuek ~-~-
*/
--
TIP 5: ¿Has leído nuestro extenso FAQ?
http://www.postgresql.org/docs/faqs.FAQ.html

No comments: