BUG #14017: strange syntax error

From: anthony(at)arkia(dot)nl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14017: strange syntax error
Date: 2016-03-12 10:09:50
Message-ID: 20160312100950.8904.56439@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14017
Logged by: Anthony van den Berg
Email address: anthony(at)arkia(dot)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;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-03-12 16:03:49 Re: BUG #14017: strange syntax error
Previous Message Tom Lane 2016-03-12 04:06:03 Re: BUG #13440: unaccent does not remove all diacritics