File: topoelement.sql

package info (click to toggle)
postgis 2.5.1%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 75,792 kB
  • sloc: ansic: 139,314; sql: 136,281; xml: 48,954; sh: 4,906; perl: 4,509; makefile: 2,897; python: 1,198; yacc: 441; cpp: 305; lex: 132
file content (9 lines) | stat: -rw-r--r-- 405 bytes parent folder | download | duplicates (12) 
1
2
3
4
5
6
7
8
9
 
-- Good
SELECT '1','{101,1}'::topology.TopoElement;
SELECT '2','{101,2}'::topology.TopoElement;
SELECT '3','{101,3}'::topology.TopoElement;
SELECT '4','{1,104}'::topology.TopoElement; -- layer id has no higher limit
-- Invalid: has 3 elements
SELECT '[0:2]={1,2,3}'::topology.TopoElement;
-- Invalid: 0 is both an invalid primitive element id and an invalid layer id
SELECT '{1,0}'::topology.TopoElement;