From: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
---|---|
To: | Miguel Miranda <mmiranda(at)123(dot)com(dot)sv> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Cast de Parametros? |
Date: | 2005-06-15 21:49:46 |
Message-ID: | 20050615214946.GB12840@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On Wed, Jun 15, 2005 at 03:40:13PM -0600, Miguel Miranda wrote:
> CREATE OR REPLACE FUNCTION provisonar_pines(varchar, integer, numeric,
> date, integer)
> cuando lo ejecuto esto es lo que obtengo
>
> select * from provisionar_pines('3251724967',1,3.00,'2006-06-15',1350);
>
> ERROR: function provisionar_pines("unknown", integer, numeric,
> "unknown", integer) does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.
select * from provisionar_pines('3251724967'::varchar, 1, 3.00,
'2006-06-15'::date, 1350);
Sospecho que tambien funcionaria sin el primer cast, es decir,
select * from provisionar_pines('3251724967', 1, 3.00,
'2006-06-15'::date, 1350);
--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)
From | Date | Subject | |
---|---|---|---|
Next Message | Patricio Muñoz | 2005-06-15 21:53:31 | Re: Cast de Parametros? |
Previous Message | Alvaro Herrera | 2005-06-15 21:47:36 | Re: Hola buenos Dias? Es pecado pedir ayuda? |