[postgis-users] Postgis functions returning hidden weird characters! (?)

[Vyron Antoniou]

Hi,

Check this out:

select assvg(difference(
LineFromText('LINESTRING(535568 198842,535549 198802,535505 198820,535524
198862,535568 198842)'),
difference(LineFromText('LINESTRING(535568 198842,535549 198802,535505
198820,535524 198862,535568 198842)'), LineFromText('LINESTRING(535900
198600,535900 199100)'))
),0,5)

Returns: empty row

But

select length(assvg(difference(
LineFromText('LINESTRING(535568 198842,535549 198802,535505 198820,535524
198862,535568 198842)'),
difference(LineFromText('LINESTRING(535568 198842,535549 198802,535505
198820,535524 198862,535568 198842)'), LineFromText('LINESTRING(535900
198600,535900 199100)'))
),0,5))

Returns: 5

Any ideas?

Cheers,
Byron