From: | Miguel Miranda <mmiranda(at)123(dot)com(dot)sv> |
---|---|
To: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Cast de Parametros? |
Date: | 2005-06-15 21:58:36 |
Message-ID: | 42B0A48C.4050905@123.com.sv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Alvaro Herrera wrote:
> select * from provisionar_pines('3251724967'::varchar, 1, 3.00,
> '2006-06-15'::date, 1350);
>
Nope.
nap=# select * from provisionar_pines('3251724967'::varchar, 1, 3.00,
'2006-06-15'::date, 1350);
ERROR: function provisionar_pines(character varying, integer, numeric,
date, integer) does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit type casts.
> Sospecho que tambien funcionaria sin el primer cast, es decir,
>
> select * from provisionar_pines('3251724967', 1, 3.00,
> '2006-06-15'::date, 1350);
Tampoco este.
nap=# select * from provisionar_pines('3251724967', 1, 3.00,
'2006-06-15'::date, 1350);
ERROR: function provisionar_pines("unknown", integer, numeric, date,
integer) does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit type casts.
nap=#
Antes (en 7.3) no necesitaba explicit type casts, que pudo haber
cambiado, solamente hice un dump/reload anted de actualizar la version
de postgres.
Saludos
---
Miguel M.
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Miranda | 2005-06-15 22:16:54 | Re: Cast de Parametros? |
Previous Message | Patricio Muñoz | 2005-06-15 21:53:31 | Re: Cast de Parametros? |