Re: [BUGS] BUG #14693: create materialized view forces btrim

isb0459@gmail.com writes:
> I am trying to create a materialized view. I have a working SQL query that
> uses this expression: coalesce(trim(foo), bar). When I use that in the
> definition for create materialized view, Postgres force replaces the trim()
> call into a btrim() and breaks the query result.

trim() *is* btrim().  Whatever's going on here, you've leapt to an
incorrect conclusion about the cause.  How about showing us a
self-contained example of your problem?

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs