1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
--
-- functions operating on featureloc ranges
--
DECLARE FUNCTION featureloc_slice(
fmin INTEGER,
fmax INTEGER)
RETURNS SETOF featureloc;
COMMENT ON FUNCTION featureloc_slice(INT,INT) IS
'
returns all featurelocs with coordinates that intersect fmin and fmax
';
DECLARE FUNCTION featureloc_slice(
srcfeature_name VARCHAR,
fmin INTEGER,
fmax INTEGER)
RETURNS SETOF featureloc;
COMMENT ON FUNCTION featureloc_slice(VARCHAR,INT,INT) IS
'
returns all featurelocs with coordinates that intersect fmin and fmax
and located relative to srcfeature (specified by srcfeature.name)
';
DECLARE FUNCTION featureloc_slice(
srcfeature_id INTEGER,
fmin INTEGER,
fmax INTEGER)
RETURNS SETOF featureloc;
COMMENT ON FUNCTION featureloc_slice(INT,INT,INT) IS
'
returns all featurelocs with coordinates that intersect fmin and fmax
and located relative to srcfeature (specified by id)
';
|
