<font face="sans-serif" size="2">Applies to PgAdmin 1.10.0, PostGIS (in general)</font><br /><br /><font
face="sans-serif"size="2">When working with geodata (using PostGIS in PostgreSQL) its often neccessary to make joins
thatare not regular joins (see the example below), and use all kinds of special processing functions. It is not
possibleto enter them in the graphical query builder which would be a great enhancement.</font><br /><br /><font
face="sans-serif"size="2">The real problem is that, when entering the SQL manually using functions, and you switch to
thegraphical query builder, it can't handle this and crashes. Or it doesn't crash, but when returning to the SQL-editor
tabthe information entered manually is lost. I hope that this can be solved!</font><br /><br /><font face="sans-serif"
size="2">Examplefunction in the "SELECT" clause:</font><br /><font face="sans-serif" size="2">SELECT zipcode,
ST_PointOnSurface(shape)</font><br/><br /><font face="sans-serif" size="2">This could be part of a "WHERE" clause to
jointwo tables spatially:</font><br /><font face="sans-serif" size="2">ST_Intersects(nl.adm_pc4_2009.shape,
nl.adm_gem_2008_lw.shape)</font><br/><br /><font face="sans-serif" size="2">Furthermore, the query builder should be
ableto deal with grouping etc.</font><br /><br /><font face="sans-serif" size="2">Regards,</font><br /><font
face="sans-serif"size="2">Wouter<br /></font><font color="blue" face="Verdana" size="1"><u><br /></u></font><a
href="http://www.rivm.nl/disclaimer.htm"target="_new"><font color="blue" face="Verdana" size="1"><u><br /> Disclaimer
RIVM</u></font></a>
