isb0459(at)gmail(dot)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