Re: Cast de Parametros?

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)