Hi
I had to write big sql code returning max 10 rows (3 selects 7,10 and 13
joins,
mostly equi-joins - too long to include). I tried do solve this in
different ways:
1. create view
Look at simple test.sql in attachement. Just make psql -f test.sql. I
have PostgreSQL 7.1.2.
I'm used to C,C++, no
May be, in a far future, will be better to have a stored procedures which
will able to accept input arguments and output arguments?
Aug 8, 09:26 -0700, Josh Berkus wrote:
> Chris,
>
> > The called function (test2() in the example) will MODIFY the two
> > arguments
> > and then return a true val
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
pro
;[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 10:06 AM
Subject: Re: [SQL] Functions returning more than one value
> Chris,
>
> > How can I get more than one value back from a function?
>
> I assume that you're looking for a workaround here. You've been on the
&
Hi all,
How can I get more than one value back from a function?
I have a situation here, where a function needs to return a value - but also
needs to indicate from which type of record the value comes.
The most elegant would be something like the 2 functions listed below. They
don't work, since
