dollar-quoting trouble

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