<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>I an collecting geometries as in this expression.</DIV>
<DIV> </DIV>
<DIV>update num_search</DIV>
<DIV> set the_geom4 =</DIV>
<DIV> (select st_union(st_union(st_union(st_buffer(a.mbr,
buff), st_buffer(b.mbr, buff)),</DIV>
<DIV> st_buffer(bob.face.mbr,
buff))) </DIV>
<DIV> from bob.face a, bob.face b, num_search,
bob.face</DIV>
<DIV> where (st_touches(a.mbr, b.mbr)</DIV>
<DIV> and st_intersects(a.mbr, num_search.the_geom2))</DIV>
<DIV> and st_intersects(bob.face.mbr,
num_search.the_geom2));</DIV>
<DIV> </DIV>
<DIV>When I reference the_geom4 with a geometry number st_geometryn, the numbers
are in a random order. (example1,3,2,5,4,6)</DIV>
<DIV> </DIV>
<DIV>Is there a method that can be used to sort them in either ascending or
descending order??</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></DIV></DIV></BODY></HTML>