dollar-quoting trouble - Mailing list pgsql-general

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