BUG #14017: strange syntax error

Поиск
Список
Период
Сортировка
От anthony@arkia.nl
Тема BUG #14017: strange syntax error
Дата
Msg-id 20160312100950.8904.56439@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14017: strange syntax error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14017
Logged by:          Anthony van den Berg
Email address:      anthony@arkia.nl
PostgreSQL version: 9.5.1
Operating system:   linux both fedra and ubuntu
Description:

When running the create or replace function on the following I get this
error

ERROR:  syntax error at or near "("
LINE 5: ...trim(isnull(new.straat,''::text) || ' ' || isnull (  new.hui...


in postgresql 9.4.5 it gives no problem

I have no idea why this happens ans the first isnull call is exactly the
same als the second

CREATE OR REPLACE FUNCTION relaties.update_insert_adressen()
  RETURNS trigger AS
$BODY$
BEGIN
    new.adres = trim(isnull(new.straat,''::text) || ' ' || isnull (
new.huisnummer,''::text));
    return new;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION relaties.update_insert_adressen()
  OWNER TO postgres;



the isnull function looks like this.



CREATE OR REPLACE FUNCTION public."isnull"(
    text,
    text)
  RETURNS text AS
$BODY$SELECT (CASE (SELECT $1
is null) WHEN true THEN $2 ELSE $1 END) AS RESULT$BODY$
  LANGUAGE sql VOLATILE
  COST 100;
ALTER FUNCTION public."isnull"(text, text)
  OWNER TO postgres;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13440: unaccent does not remove all diacritics
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14017: strange syntax error