[postgis-users] select a, b, c, case statement is not robust - no error message

[Shaozhong SHI]

Hi,

One of my scripts worked very well, but for unknown reasons, it does not
work.

It is something like the following:

select a, b, c, case statement as d from a_table;

The case statement has a lot of cases, which are joined by using ||.

Data is certainly there, but the result of case statement as d is empty.

Any other robust way to deal with this?

Can anyone enlighten me?

Regards,

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210105/3cf14c7e/attachment.html>