I have tried to make a plgpsql function that accumulate a set of
integers, but I find no way of doing this in the PostgreSQL
documentation. I have made a very simple example to demonstrate my
CREATE FUNCTION fn_integer_list( INTEGER )
RETURNS SETOF INTEGER AS '
SETOF INTEGER res;
res := 1;
res := res + $1;
There is really two problems here. How does one initialize a set of
integers, and how does one append a new value to the setof integers ?
This example does, of course, not work :-)
If there is a reference to some documentation I should read, I will be
happy for any hint in its direction.
pgsql-novice by date
|Next:||From: Jason Tan||Date: 2001-09-12 06:51:49|
|Subject: Re: accumulate setof ?|
|Previous:||From: Jason Tan||Date: 2001-09-11 05:30:06|
|Subject: Re: Path for pgsql \i option?|