On Apr 25, 2005, at 3:40 PM, Ruff, Jeffry C. SR. wrote:
> I found this function on line [Thanks to Jeff Eckermann and Juerg
> Rietmann] that takes the results of a query and creates a comma
> delimited string. However when I run it I get no values. Any help
> would be appreciated. I apologize if this is the wrong forum.
Try changing
string text := NULL;
to
string text := '';
Any text concatenated with NULL results in a NULL value.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL