Re: Cast de Parametros?

Mandanos esto:

nap=# \df+ provisionar_pines

El Mié 15 Jun 2005 18:58, Miguel Miranda escribió:
> 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.
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 7: no olvides aumentar la configuración del "free space map"
>
>

--
19:14:25 up 9 days, 7:05, 2 users, load average: 2.08, 1.67, 1.79
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------