545 lines
28 KiB
SQL
545 lines
28 KiB
SQL
-- POINT
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT(0 0)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT Z (1 2 3)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT M (1 2 3)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POINT ZM (1 2 3 4)'
|
|
::text as g ) as foo;
|
|
|
|
-- MULTIPOINT
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT((0 0), (2 0))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT Z ((0 0 0), (2 0 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT M ((0 0 2), (2 0 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOINT ZM ((0 1 2 3), (3 2 1 0))'
|
|
::text as g ) as foo;
|
|
|
|
-- LINESTRING
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING(0 0, 1 1)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING Z (0 0 2, 1 1 3)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING M (0 0 2, 1 1 3)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'LINESTRING ZM (0 0 2 3, 1 1 4 5)'
|
|
::text as g ) as foo;
|
|
|
|
-- MULTILINESTRING
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING((0 0, 2 0))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING((0 0, 2 0), (1 1, 2 2))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING Z ((0 0 1, 2 0 2), (1 1 3, 2 2 4))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING M ((0 0 1, 2 0 2), (1 1 3, 2 2 4))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTILINESTRING ZM ((0 0 1 5, 2 0 2 4), (1 1 3 3, 2 2 4 2))'
|
|
::text as g ) as foo;
|
|
|
|
-- POLYGON
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON((0 0,1 0,1 1,0 1,0 0))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,2 5,5 5,5 2,2 2))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON Z ((0 0 1,10 0 2 ,10 10 2,0 10 2,0 0 1),(2 2 5 ,2 5 4,5 5 3,5 2 3,2 2 5))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON M ((0 0 1,10 0 2 ,10 10 2,0 10 2,0 0 1),(2 2 5 ,2 5 4,5 5 3,5 2 3,2 2 5))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYGON ZM ((0 0 1 -1,10 0 2 -2,10 10 2 -2,0 10 2 -4,0 0 1 -1),(2 2 5 0,2 5 4 1,5 5 3 2,5 2 3 1,2 2 5 0))'
|
|
::text as g ) as foo;
|
|
|
|
-- MULTIPOLYGON
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(2 2,2 5,5 5,5 2,2 2)))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON Z (((0 0 3,10 0 3,10 10 3,0 10 3,0 0 3),(2 2 3,2 5 3,5 5 3,5 2 3,2 2 3)))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON M (((0 0 3,10 0 3,10 10 3,0 10 3,0 0 3),(2 2 3,2 5 3,5 5 3,5 2 3,2 2 3)))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTIPOLYGON ZM (((0 0 3 2,10 0 3 2,10 10 3 2,0 10 3 2,0 0 3 2),(2 2 3 2,2 5 3 2,5 5 3 2,5 2 3 2,2 2 3 2)))'
|
|
::text as g ) as foo;
|
|
|
|
-- GEOMETRYCOLLECTION
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION ZM (POINT ZM (0 0 0 0),LINESTRING ZM (0 0 0 0,1 1 1 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1))),POINT M EMPTY,GEOMETRYCOLLECTION M (POINT M (0 0 0),LINESTRING M (0 0 0,1 1 1)))'
|
|
::text as g ) as foo;
|
|
|
|
-- CIRCULARSTRING
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING (0 0,1 1, 2 0)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING M (0 0 1,1 1 1, 2 0 1)'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CIRCULARSTRING ZM (0 0 1 2,1 1 1 2, 2 0 1 2)'
|
|
::text as g ) as foo;
|
|
|
|
-- COMPOUNDCURVE
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE (CIRCULARSTRING (0 0,1 1,2 0),LINESTRING(2 0,4 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE Z (CIRCULARSTRING Z (0 0 1,1 1 1,2 0 1),LINESTRING Z (2 0 0,4 1 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE M (CIRCULARSTRING M (0 0 1,1 1 1,2 0 1),LINESTRING M (2 0 0,4 1 1))'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'COMPOUNDCURVE ZM (CIRCULARSTRING ZM (0 0 1 2,1 1 1 2,2 0 1 2),LINESTRING ZM (2 0 0 0,4 1 1 1))'
|
|
::text as g ) as foo;
|
|
|
|
-- CURVEPOLYGON
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CURVEPOLYGON EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CURVEPOLYGON Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CURVEPOLYGON M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CURVEPOLYGON ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'CURVEPOLYGON ZM (COMPOUNDCURVE ZM (CIRCULARSTRING ZM (0 0 1 2,1 1 1 2,2 0 1 2),LINESTRING(2 0 1 2,1 -1 1 1,0 0 1 2)))'
|
|
::text as g ) as foo;
|
|
|
|
-- MULTICURVE
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTICURVE EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTICURVE Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTICURVE M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTICURVE ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTICURVE ZM (COMPOUNDCURVE ZM (CIRCULARSTRING ZM (0 0 1 2,1 1 1 2,2 0 1 2),LINESTRING(2 0 1 2,1 -1 1 1,0 0 1 2)))'
|
|
::text as g ) as foo;
|
|
|
|
-- MULTISURFACE
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTISURFACE EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTISURFACE Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTISURFACE M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTISURFACE ZM EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'MULTISURFACE ZM (CURVEPOLYGON ZM (COMPOUNDCURVE ZM (CIRCULARSTRING ZM (0 0 1 2,1 1 1 2,2 0 1 2),LINESTRING(2 0 1 2,1 -1 1 1,0 0 1 2))),POLYGON((10 10 10 10,10 12 10 10,12 12 10 10,12 10 10 10,10 10 10 10)))'
|
|
::text as g ) as foo;
|
|
|
|
-- POLYHEDRALSURFACE
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYHEDRALSURFACE EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYHEDRALSURFACE Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYHEDRALSURFACE M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'POLYHEDRALSURFACE ZM EMPTY'
|
|
::text as g ) as foo;
|
|
|
|
-- TRIANGLE
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TRIANGLE EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TRIANGLE Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TRIANGLE M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TRIANGLE ZM EMPTY'
|
|
::text as g ) as foo;
|
|
|
|
-- TIN
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TIN EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TIN Z EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TIN M EMPTY'
|
|
::text as g ) as foo;
|
|
select g, encode(st_asbinary(g::geometry, 'ndr'), 'hex'),
|
|
st_orderingequals(g::geometry, ST_GeomFromWKB(ST_AsBinary(g::geometry))),
|
|
encode(st_asbinary(g::geometry, 'xdr'), 'hex') FROM ( SELECT
|
|
'TIN ZM EMPTY'
|
|
::text as g ) as foo;
|
|
|
|
|
|
-- Crashes (#4767, #4768, #4771, #4772)
|
|
SELECT st_mpointfromwkb('\x'::BYTEA);
|
|
SELECT geometry('\x'::bytea);
|
|
SELECT st_geomcollfromwkb('\x'::bytea);
|
|
SELECT st_geomfromewkb('\x'::bytea);
|
|
SELECT st_wkbtosql('\x');
|
|
SELECT st_mpolyfromwkb('\x'::BYTEA);
|
|
SELECT st_mlinefromwkb('\x'::bytea);
|
|
SELECT st_mlinefromwkb('\x'::bytea,1); |