<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><br></div><div dir="ltr"><a href="https://postgis.net/workshops/postgis-intro/validity.html">23. Validity — Introduction to PostGIS</a><br></div><div>last code block, </div><div><pre style="line-height:15.96px;margin-top:0px;margin-bottom:0px;overflow:auto hidden;clear:both;font-family:Consolas,"Deja Vu Sans Mono","Bitstream Vera Sans Mono",monospace;font-size:0.95em;letter-spacing:0.015em;padding:0.5em;border:1px solid rgb(204,204,204);color:rgb(0,0,0)"><span class="gmail-c1" style="color:rgb(64,128,144);font-style:italic">-- Fix invalid and save the original</span>
<span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">UPDATE</span> <span class="gmail-n">nyc_neighborhoods</span>
  <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">SET</span> <span class="gmail-n">geom</span> <span class="gmail-o" style="color:rgb(102,102,102)">=</span> <span class="gmail-n">ST_MakeValid</span><span class="gmail-p">(</span><span class="gmail-n">geom</span><span class="gmail-p">),</span>
      <span class="gmail-n">invalid_geom</span> <span class="gmail-o" style="color:rgb(102,102,102)">=</span> <span class="gmail-n">geom</span>
  <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">WHERE</span> <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">NOT</span> <span class="gmail-n">ST_IsValid</span><span class="gmail-p">(</span><span class="gmail-n">geom</span><span class="gmail-p">);</span></pre></div><div><br></div><div>I think it should be:</div><div><pre style="line-height:15.96px;margin-top:0px;margin-bottom:0px;overflow:auto hidden;clear:both;font-family:Consolas,"Deja Vu Sans Mono","Bitstream Vera Sans Mono",monospace;font-size:0.95em;letter-spacing:0.015em;padding:0.5em;border:1px solid rgb(204,204,204);color:rgb(0,0,0)"><span class="gmail-c1" style="color:rgb(64,128,144);font-style:italic">-- Fix invalid and save the original</span>
<span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">UPDATE</span> <span class="gmail-n">nyc_neighborhoods</span>
  <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">SET</span> <span class="gmail-n">geom</span> <span class="gmail-o" style="color:rgb(102,102,102)">=</span> <span class="gmail-n">ST_MakeValid</span><span class="gmail-p">(</span><span class="gmail-n">geom</span><span class="gmail-p">),</span>
      geom_invalid<span style="font-size:0.95em;letter-spacing:0.015em"> </span>=<span style="font-size:0.95em;letter-spacing:0.015em"> </span><span class="gmail-n" style="font-size:0.95em;letter-spacing:0.015em">geom</span><br>  <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">WHERE</span> <span class="gmail-k" style="color:rgb(0,112,32);font-weight:bold">NOT</span> <span class="gmail-n">ST_IsValid</span><span class="gmail-p">(</span><span class="gmail-n">geom</span><span class="gmail-p">);</span></pre></div><div><br></div></div></div></div></div>