Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql function not working - Mailing list pgsql-general

From John DeSoi
Subject Re: plpgsql function not working
Date
Msg-id 6CF09894-B5C6-11D9-B125-000A95B03262@pgedit.com
Whole thread Raw
In response to plpgsql function not working  ("Ruff, Jeffry C. SR." <jeffry.ruff@tycoelectronics.com>)
List pgsql-general
Tree view 
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 DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: plpgsql function not working
Next
From: "David Parker"
Date:
Subject: rollback vs. commit for closing read-only transaction