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 mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql function not working
Date: 2005-04-25 20:13:01
Message-ID: 6CF09894-B5C6-11D9-B125-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Browse pgsql-general by date

  From Date Subject
Next Message David Parker 2005-04-25 21:43:40 rollback vs. commit for closing read-only transaction
Previous Message Bruno Wolff III 2005-04-25 20:10:46 Re: Calculated bigserial column in a view