[postgis-users] St_within problem

[Maxime van Noppen]

Michael Smedberg wrote:
> You can use the astext function to get the WKT ("well known text".)
> E.g. you could do something like:
> 
> SELECT astext(the_geom) FROM library.dgm_process
> 
> which would return a textual representation of the geometries.
> ST_GeomFromText is the opposite of astext- it'll convert the text to a
> geometry object.

I suggest the use of the binary WKB format to avoid precision quirks
that might occur with WKT.

SELECT ST_AsBinary(the_geom) FROM ...;

-- 
Maxime