dollar-quoting trouble

[Karsten Hilbert <Karsten.Hilbert@xxxxxxx>]

Hi all,

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


Can anyone help ?

Thanks,
Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346