Re: Functions returning more than one value

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