Re: dollar-quoting trouble

On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
>     returns trigger
>     language plpgsql
>     as $null_empty_title$
> begin
>     if (NEW.title is null) then
>         return NEW;
>     end if;
>
>     if trim(NEW.title) <> '' then
>         return NEW;
>     end if;
>
>     NEW.title := NULL;
>     return NEW;
> end;
> $null_empty_title$;
>
>
> PostgreSQL 8.1.8 (Debian/Etch) is telling me:
>
> psql:dem-identity.sql:43: ERROR:  unterminated dollar-quoted string at or near "$null_empty_title$
> begin
>         if (NEW.title is null) then
>                 return NEW;" at character 83

Does "psql --version" match "select version()"?  There's a message in
the archive pgsql-bugs where this happened.

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg@kgb.une.edu.au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+