| 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: | Whole Thread | Raw Message | 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/
| 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 |