Search Postgresql Archives

Re: Datatypes in PL/PSQL functions with multiple arguments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Benjamin Holmberg wrote:
Hello-

This is my first foray into pl/psql so forgive me if I sound totally incompetent.

I've been writing a few functions, and have come across some screwing data typing issues.

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.

Could you perhaps give an example function? Something with one or two lines of code perhaps. Oh, and how you are calling it too.


--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux