Re: Error while executing a view in postgres 10.5

Hi,

> ERROR: set-returning functions are not allowed in CASE
> LINE 37: else regexp_split_to_table(privs,E'\...
> ^
> HINT: You might be able to move the set-returning function into a LATERAL
> FROM item.

Starting in PostgreSQL 10, set-returning functions are no longer
allowed in CASE statements[1].

As it suggests, you can try moving the expression to a LATERAL
subquery[2]. Taking a quick look at the query, you would need
to rewrite a good portion of it in order to do so, but it would then
work with the updated versions of PostgreSQL.

Jonathan

[1] https://www.postgresql.org/docs/release/10.0/ <https://www.postgresql.org/docs/release/10.0/> - search for
“Change the implementation of set-returning functions”
[2] https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL <https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL>