File: getringedges.sql

package info (click to toggle)
postgis 3.3.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 87,748 kB
  • sloc: ansic: 158,671; sql: 91,546; xml: 54,004; cpp: 12,339; sh: 5,187; perl: 5,100; makefile: 3,085; python: 1,205; yacc: 447; lex: 151; javascript: 6
file content (16 lines) | stat: -rw-r--r-- 563 bytes parent folder | download | duplicates (5)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
set client_min_messages to ERROR;

\i :top_builddir/topology/test/load_topology.sql

-- Test bogus calls
SELECT 'non-existent-topo', topology.GetRingEdges('non-existent', 1);
SELECT 'non-existent-edge', topology.GetRingEdges('city_data', 10000000);
SELECT 'non-existent-edge-negative', topology.GetRingEdges('city_data', -10000000);

SELECT 'R'||edge_id, (topology.GetRingEdges('city_data', edge_id)).*
	FROM city_data.edge;

SELECT 'R-'||edge_id, (topology.GetRingEdges('city_data', -edge_id)).*
	FROM city_data.edge;

SELECT topology.DropTopology('city_data');