Chris,
> The called function (test2() in the example) will MODIFY the two
> arguments
> and then return a true value. After test2() has run, the value of the
> two
> arguments 'has changed' to what test2() has assigned to them.
I understand, now. You're trying to replicate the functionality
provided in programming languages using By Reference arguments.
I could suggest a number of workarounds. However, I think rather that
you should give serious consideration to *not* doing this in PL/pgSQL
but doing it in a full-featured procedural (and/or Object Oriented)
language instead. Java, Python, Perl and even 4GL would provide you
with more robust functionality.
For example, what you want is easily done in Java just by passing the
input parameters as By Reference.
Opinions on Middleware languages, anyone?
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco