[postgis-users] linux strange geometry columns

[strk at refractions.net]

On Fri, Jun 16, 2006 at 02:17:38PM +0200, francesco wrote:
> hello folks,
> 
> does anyone know why when I put postgis data in postgres server in my linux 
> machine the geometry column looks odd?
> 
> These are the values I get instead of the good old 
> "SRID=26591;POINT(1400110.156 4851149.612) " ....
> 
> 0101000020DF670000250681755C6235410E2DB26D8D825241
> 0101000020DF6700008FC2F5C8A0633541819543CB4F825241
> 0101000020DF6700005A643B1F04793541CDCCCC9CBD835241
> 0101000020DF67000060E5D0A2037935415A643BA7B8835241
> 
> It reads the data perfectly from mapserver, but I cannot use a filter on 
> the data type because my sql function looks for key words like "POINT" and 
> "LINE" which of course it does not find in that bunch of numbers....

Use geometrytype(geometry) to filter on data type.

--strk;