Regina Obe
d02637045e
and into geobuf suite to prevent failure on systems not compiled with protobuf-c Closes #4983
39 lines
2.2 KiB
SQL
39 lines
2.2 KiB
SQL
--set client_min_messages to DEBUG3;
|
|
SELECT 'T1', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_MakePoint(1.1, 2.1) AS geom) AS q;
|
|
SELECT 'T2', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT 'test' as test_str, 1 as test_pos_int, -1 as test_neg_int, 1.1 as test_numeric, 1.1::float as test_float, ST_MakeLine(ST_MakePoint(1,1), ST_MakePoint(2,2)) as geom) AS q;
|
|
SELECT 'T3', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))') as geom) AS q;
|
|
SELECT 'T4', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('POLYGON((0 0,0 5,5 5,5 0,0 0), (1 1,1 2,2 2,2 1,1 1))') as geom) AS q;
|
|
SELECT 'T5', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('MULTIPOINT (10 40, 40 30, 20 20, 30 10)') as geom) AS q;
|
|
SELECT 'T6', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40), (40 40, 30 30, 40 20, 30 10))') as geom) AS q;
|
|
SELECT 'T7', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), ((20 35, 10 30, 10 10, 30 5, 45 20, 20 35), (30 20, 20 15, 20 25, 30 20)))') as geom) AS q;
|
|
SELECT 'T8', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_GeomFromText('GEOMETRYCOLLECTION(POINT(4 6),LINESTRING(4 6,7 10))') as geom) AS q;
|
|
SELECT 'T9', encode(ST_AsGeobuf(q, 'geom'), 'base64')
|
|
FROM (SELECT ST_MakePoint(1, 2, 3) as geom) AS q;
|
|
SELECT 'T10', encode(ST_AsGeobuf(q), 'base64')
|
|
FROM (SELECT ST_MakePoint(1, 2, 3) as geom) AS q;
|
|
|
|
WITH geom AS (
|
|
SELECT 'TRIANGLE((0 0, 1 1, 0 1, 0 0))'::geometry geom
|
|
union all
|
|
SELECT 'TIN(((0 0, 1 1, 0 1, 0 0)))'::geometry geom
|
|
union all
|
|
SELECT 'TRIANGLE EMPTY'::geometry geom
|
|
)
|
|
select '#4399', 'ST_AsGeobuf', ST_AsGeobuf(geom.*)::text from geom;
|
|
|
|
SELECT '#4916.a', ST_AsGeobuf(NULL::pg_class, 'g') over (order by b)
|
|
FROM (VALUES ('POINT(0 0)'::geometry, 'A0006', 300),
|
|
('POINT(1 1)'::geometry, 'A0006', 302)) t(g, a, b);
|
|
|
|
SELECT '#4916.b', ST_AsGeobuf(NULL::pg_class) over (order by b)
|
|
FROM (VALUES ('POINT(0 0)'::geometry, 'A0006', 300),
|
|
('POINT(1 1)'::geometry, 'A0006', 302)) t(g, a, b);
|