Re: [postgis-users] st_astext() created invalid

You've got a visible example of why the canonical format of PostGIS is hexwbk, and not wkt, as it was in the 0.x versions. The human readable output is not quite exactly the same as the binary representation. Since your geometry is just a hair's breadth from being invalid, maybe you should just acc

Re: [postgis-users] st_astext() created invalid

Ack, I forgot version information: SELECT version() || ' ' || postgis_full_version(); ?column? --

[postgis-users] st_astext() created invalid

Not sure I understand what is happening here. I have a geom: select * from my_temp ; geom ---