[GENERAL] dollar-quoting trouble

[Karsten Hilbert]

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

---------------------------(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