Re: plpgsql function errors - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: plpgsql function errors
Date
Msg-id 20050204185542.GG14840@svana.org
Whole thread Raw
In response to plpgsql function errors  ("Juan Casero (FL FLC)" <Juan.Casero@wholefoods.com>)
List pgsql-general
On Fri, Feb 04, 2005 at 12:44:35PM -0600, Juan Casero (FL FLC) wrote:
> Sorry about that.  I did forget one parameter...
>
> customer_service=# select
> trx_id('JUANCASERO3055128218',805,'CREDIT','02/02/05','1','1','Aventura'
> ,'02/01/05','Tom');
> ERROR:  function trx_id("unknown", integer, "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.

Please post the output of: \df+ trx_id

That will tell you what parameters it expects.
--
Martijn van Oosterhout   <kleptog@svana.org>   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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: plpgsql function errors
Next
From: David Fetter
Date:
Subject: Re: Questions about functionality