Re: plpgsql function not working

From: John DeSoi <desoi(at)pgedit(dot)com>
To: "Ruff, Jeffry C(dot) SR(dot)" <jeffry(dot)ruff(at)tycoelectronics(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql function not working
Date: 2005-04-25 19:59:46
Message-ID: 92BE7614-B5C4-11D9-B125-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Typing80wpm 2005-04-25 20:01:37 Toad Adm. Datasource Location
Previous Message John DeSoi 2005-04-25 19:48:33 Re: column size in libpq