| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Ing(dot) Eris J(dot) Gómez <eris_jose(at)hotmail(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Funcion no funciona |
| Date: | 2009-08-14 16:44:11 |
| Message-ID: | 20090814164411.GG7533@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Ing. Eris J. Gómez escribió:
> Hola a todos.
>
> Escribi una funcion y no trabaja correctamente. Que estoy haciendo mal?
> *- A continuacion el Script.
>
> ---
> CREATE OR REPLACE FUNCTION "public"."cxp_balfactura" (x_codcia char, x_suplidor char, x_factura char, x_monto numeric, x_moneda integer) RETURNS numeric AS
Yo probaría declarando esos parámetros como varchar, no char.
Regla general: jamás uses char.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
Thou shalt study thy libraries and strive not to reinvent them without
cause, that thy code may be short and readable and thy days pleasant
and productive. (7th Commandment for C Programmers)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ing. Eris J. Gómez | 2009-08-14 16:50:20 | Funcion no funciona |
| Previous Message | Alvaro Herrera | 2009-08-14 16:42:45 | Re: Conexiones persistentes y pg_pool |