ST_Dumppoints Problem with different server version

Hello Members,

I ran following query in Postgres Server 9.1 (Postgis 1.5) and Postgres Server 10 (Postgis 2.0)

select 
    st_astext((
	st_dumppoints(
		'GEOMETRYCOLLECTION(
			MULTILINESTRING(
				(0 0,1 1,1 2),
				(2 3,3 2,5 4)
			),
			MULTIPOLYGON(
				((0 0,4 0,4 4,0 4,0 0),(1 1,2 1,2 2,1 2,1 1)), 
				((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1))
			)
		)'
	)
).geom)

It gives different results in both servers. The Output in 9.1 is correct.

Kindly Help

Thank you

Both, 9.1/1.5 and 10/2.0 ist really old. There might have happened a lot of changes, like i.e. the handling of geometries with no srid or geometrycollections or something else.
And you did not tell us the difference between your results.

Greetings
Uwe

Dieses Thema wurde automatisch 60 Tage nach der letzten Antwort geschlossen. Es sind keine neuen Antworten mehr erlaubt.