Re: Datatypes in PL/PSQL functions with multiple arguments

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Benjamin Holmberg <benjamin(dot)holmberg(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Datatypes in PL/PSQL functions with multiple arguments
Date: 2005-04-19 15:18:18
Message-ID: 20050419151818.GA80847@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 19, 2005 at 10:01:26AM -0500, Benjamin Holmberg wrote:
>
> When creating a function which accepts a single argument, things work just
> fine, variable can be used throughout the function as expected with no
> modification.
> When creating functions containing two or more arguments, I have to
> explicity cast the arguments whenever I use them (loading/casting into
> another variable is an option, haven't tried though) to prevent runtime
> errors. The functions get called just fine, but then run into problems using
> any of the given arguments.

Please post an example of what you're doing: a simple function, how
you're invoking it, and the error message(s).

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Don Isgitt 2005-04-19 15:19:34 substring and POSIX re's
Previous Message Richard Huxton 2005-04-19 15:10:38 Re: Datatypes in PL/PSQL functions with multiple arguments