dollar-quoting trouble
От | Karsten Hilbert |
---|---|
Тема | dollar-quoting trouble |
Дата | |
Msg-id | 20070419214547.GA20270@merkur.hilbert.loc обсуждение исходный текст |
Ответы |
Re: dollar-quoting trouble
Re: dollar-quoting trouble Re: dollar-quoting trouble |
Список | 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
В списке pgsql-general по дате отправления: