On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] : 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 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly