Re: Tablas Temporales!

Sonia Malave wrote:

> Entiendo, pero me surge otra dudita, si yo hago:
> --
> ---> Inserta en la Tabla Detalle Prefactura
> --
> begin
> EXECUTE
> 'INSERT INTO
> DETALLE_PREFACTURA
> (ID_DETALLE,
> CONCEPTO,
> MONTO_CONCEPTO,
> NRO_PREFACTURA,
> TIPO_OPERACION,
> MON_TARIFA,
> CANTIDAD,
> MET_CUB_MIN)
> SELECT
> mIdDetalle,
> mNomConDetalle,
> CAST(mMonDetalle AS NUMERIC(15,2)),
> v_mNumPrefactura as xNumPrefactura,
> '0' as xTipOperacion,
> CAST(mMonTarifa AS NUMERIC(15,2)),
> CAST(mConContratado AS NUMERIC(15,2)),
> mMetCubMin
> FROM
> tt_MMONDETALLE
> WHERE
> mMonDetalle <> *0'*;
> EXCEPTION
> WHEN OTHERS
> THEN
> SWV_err := -1;
> end;
>
>
> Me da un error despues del 0', que estoy haciendo mal?.

Por eso te dije que usaras $s$ y no '.

--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"I must say, I am absolutely impressed with what pgsql's implementation of
VALUES allows me to do. It's kind of ridiculous how much "work" goes away in
my code. Too bad I can't do this at work (Oracle 8/9)." (Tom Allison)
http://archives.postgresql.org/pgsql-general/2007-06/msg00016.php