Re: dollar-quoting trouble

On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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(at)kgb(dot)une(dot)edu(dot)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 : :
+---------------------------------------+-----------------+