Connect to Postgres 10, set-returning functions are not allowed in CASE

[Connor Johnson 2]

I'm using Tibco Spotfire Analyst 7.10.0. I am trying to connect to a PostgreSQL 10.7 database. Once I connect and try to add tables in the database to views in the connection, I get the following error: "set-returning functions are not allowed in CASE". Is there a workaround for this

[Varma Nadimpalli]

Hello Connor,

It seems a defect in Spotfire and it is addressed inTS_7.11.0.76 LTS HF-003 and (Spotfire 7.13 or later versions.)

I would recommend upgrading to the latest mainstream or LTS version of Spotfire.

https://docs.tibco.com/pub/spotfire/general/LTS/spotfire_LTS_releases.htm

 

Thanks,

Varma

[Oleg Os]

Same problem in 7.8