Re: Cast de Parametros?

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.