<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007>Hi!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>I'm using PostGIS
1.2.0 and PostgreSQL 8.2. Then I run a query like (I'm using the SQL client in
PgAdmin III):</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>SELECT gid,
asgml(geom) FROM bishkekeni WHERE NOT st_isvalid(geom)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>I get a lot of text
in the message window. It looks like this: </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007>....</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>NOTICE:
Self-intersection<BR>NOTICE: Self-intersection<BR>NOTICE: Ring
Self-intersection<BR>NOTICE: Self-intersection</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007>...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>I understand that
this is the same errors that st_isvalid(geom) function is printing out. But I
would like to have the text like 'Self-intersection' on each row for the objects
that are not valid. Is there a function to print out these errors (must be I can
see them!!)? How do I use it?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>Something like
this??</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>SELECT gid,
asgml(geom), magicfunction(geom) FROM bishkekeni WHERE NOT
st_isvalid(geom)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007>Regards</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>Åke
Jennehag</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=009315405-16042007>National Land Survey
of Sweden</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=009315405-16042007></SPAN></FONT> </DIV></BODY></HTML>