diff options
Diffstat (limited to 'contrib/seg/sql')
| -rw-r--r-- | contrib/seg/sql/seg.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/seg/sql/seg.sql b/contrib/seg/sql/seg.sql index 91d771db181..61ad519613e 100644 --- a/contrib/seg/sql/seg.sql +++ b/contrib/seg/sql/seg.sql @@ -223,3 +223,7 @@ SELECT count(*) FROM test_seg WHERE s @> '11..11.3'; -- Test sorting SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s; + +-- Test functions +SELECT seg_lower(s), seg_center(s), seg_upper(s) +FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s; |