On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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@xxxxxxxxxxxxxx : 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 : : +---------------------------------------+-----------------+
