In 34.4.3. SQL Functions with Output Parameters we have:
CREATE FUNCTION sum_n_product (x int, y int, OUT sum int, OUT product
int) AS
'SELECT $1 + $2, $1 * $2'
LANGUAGE SQL;
SELECT * FROM sum_n_product(11,42);
sum | product
-+-
53 | 462
(1 row)
Then in 34.4.7. SQL Func
ts to.
I know this sounds terribly simple, but simplicity is good,
particularly when you're climbing a steep learning curve. And there
is certainly, unequivocally, no harm in simplicity.
Thanks,
John
On Jul 24, 2010, at 2:21 PM, Peter Eisentraut wrote:
On fre, 2010-07-23 at 12:02 +0
The examples in the documentation are the most valuable part.
In this section, you create the table for the example, but you do not
populate it, although the example select statements are against the
phantom population that has not been inserted.
I suggest strongly including the minimal cod
For me, the great value of a single page html file for searching the
documentation is that, at least on Firefox, if the page is loaded,
either from a file on the user's computer or from the Internet, to
search for something throughout the entire documentation one only has
to start typing wh
Ah, perhaps I have misunderstood. Double ah.
So that's the reason for the current html format: ease of browser
access.
On the other hand, the pdf file, at 17MB, is the biggest one and, as
far as I am concerned, the least useful.
I would just make the single file html and text files availa
Just to once again express my thanks for the html and text versions.
If I set it up in a particularly useful database version, I will share.
John Gage
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
