Re: Error while executing a view in postgres 10.5

"Jonathan S. Katz" <[email protected]> Fri, 22 Mar 2019 09:08:38 -0400

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<[email protected]>

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>

signature.asc (application/pgp-signature, 833 B)