Re: RE: Totalizar tablas dinamicamente

On 11/17/06, wilhelmtg(at)cantv(dot)net <wilhelmtg(at)cantv(dot)net> wrote:
> Gracias por la respuesta
>
> Estas son las dos formas de obtener el numero de registros....
> ========================================
> SELECT COUNT(*) INTO total FROM cliente;
>
> FOR rec IN SELECT COUNT(*) FROM cliente LOOP
> RETURN rec.count;
> END LOOP;
> RETURN 0;
> ========================================
>
> El detalle o error está cuando envio el nombre de la tabla como
> parametro...

No, lo que te dijeron que debes hacer es:

EXECUTE 'select count(*) from ' || quote_ident($1);

--
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