[postgis-users] select asSVG(the_geom) || 'mytext' from mytable -- does not work

[strk at refractions.net]

On Fri, Oct 15, 2004 at 12:46:30PM +0200, Jorg Heymans wrote:
> Hi,
> 
> Above construct does not work because asSVG seems to tag a newline at 
> the end of it's output.
> 
> Following works:
> select substring(asSVG(the_geom), 0, length(asSVG(the_geom))-1) 
> ||'mytext' from mytable
> 
> Thoughts?
> 
> Jorg Heymans

I've checked, the offending char was not a newline, but a random
char, which in your case (maybe all cases?) was a ZERO (EOS).

The bug is now fixed in the 0_9 and the HEAD branch.

--strk;

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users