<html><head></head><body style="zoom: 0%;"><div dir="auto">Coalesce (null,'') || coalesce ('Foo','')<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=16117"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On 6 Jan 2021, at 13:29, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi, Simon,<div>Any demo?</div><div>Regards,</div><div>David<br><br>On Wednesday, 6 January 2021, Simon Greener <<a href="mailto:simon@spatialdbadvisor.com">simon@spatialdbadvisor.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="zoom:0%"><div dir="auto">Wrap each side with coalesce.<br><br></div>
<div dir="auto">Get <a href="http://www.bluemail.me/r?b=16117" target="_blank">BlueMail for Android</a> </div>
<div class="gmail_quote">On 6 Jan 2021, at 11:16, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hi, Simon,<div>Good point. I suspect when there is null, it is a problem.</div><div>Regards,</div><div>David<br><br>On Tuesday, 5 January 2021, Simon Greener <<a href="mailto:simon@spatialdbadvisor.com" target="_blank">simon@spatialdbadvisor.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="zoom:0%"><div dir="auto">Do any of the left or right sides of a || pair return NULL?<br></div>
<div dir="auto">Simon<br><br></div>
<div dir="auto">Get <a href="http://www.bluemail.me/r?b=16117" target="_blank">BlueMail for Android</a> </div>
<div class="gmail_quote">On 6 Jan 2021, at 10:10, Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi,<div><br></div><div>One of my scripts worked very well, but for unknown reasons, it does not work.</div><div><br></div><div>It is something like the following:</div><div><br></div><div>select a, b, c, case statement as d from a_table;<br></div><div><br></div><div>The case statement has a lot of cases, which are joined by using ||.</div><div><br></div><div>Data is certainly there, but the result of case statement as d is empty.</div><div><br></div><div>Any other robust way to deal with this?</div><div><br></div><div>Can anyone enlighten me?</div><div><br></div><div>Regards,</div><div><br></div><div>David</div></div>
<pre><hr><br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br></pre></blockquote></div></div></blockquote></div>
<pre><hr><br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></pre></blockquote></div></div></blockquote></div>
<pre class="blue"><hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br></pre></blockquote></div></body></html>