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

Simon Greener simon at spatialdbadvisor.com
Tue Jan 5 15:35:16 PST 2021


Do any of the left or right sides of a || pair return NULL?
Simon

⁣Get BlueMail for Android ​

On 6 Jan 2021, 10:10, at 10:10, Shaozhong SHI <shishaozhong at gmail.com> wrote:
>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
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210106/c2685d91/attachment.html>


More information about the postgis-users mailing list