Skip site navigation (1) Skip section navigation (2)

Re: Cast de Parametros?

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 (view raw or flat)
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.

In response to

Responses

pgsql-es-ayuda by date

Next:From: Miguel MirandaDate: 2005-06-15 22:16:54
Subject: Re: Cast de Parametros?
Previous:From: Patricio MuñozDate: 2005-06-15 21:53:31
Subject: Re: Cast de Parametros?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group