On Fri, Feb 04, 2005 at 12:22:43PM -0600, Juan Casero (FL FLC) wrote:
> I tried putting those values into strings like you describe below but
> then the server bombs. e.g...
>
> customer_service=# select
> trx_id('JUANCASERO3055128218','CREDIT','02/02/05','1','1','Aventura','02
> /01/05','Tom');
> ERROR: function trx_id("unknown", "unknown", "unknown", "unknown",
> "unknown", "unknown", "unknown", "unknown") does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.
> customer_service=#
Try checking your function definition. I'm counting nine parameters but
you only gave eight...
Also, your example with type casts, you *still* need to use quotes. You
*always* need to quote strings.
--
Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
Attachment:
pgpdqL8jsTz8k.pgp
Description: PGP signature
