On Apr 25, 2005, at 4:07 PM, Ruff, Jeffry C. SR. wrote:
Thanks for the reply. After making the change I now get the following
ERROR: unterminated string
CONTEXT: compile of PL/pgSQL function "group_list" near line 6
Ok make that
string text := ;
I'm now spoiled with dollar quoting :)
John DeS
On Mon, Apr 25, 2005 at 02:40:29PM -0500, Ruff, Jeffry C. SR. wrote:
>
> CREATE FUNCTION userinfo.group_list(text) RETURNS text AS'
>DECLARE
> rec RECORD;
> string text := NULL;
>BEGIN
> FOR rec IN SELECT * FROM userinfo.userdb_groups WHERE username = $1 LOOP
>
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 i
Title: plpgsql function not working
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
