Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with union
Search options questions only
not deleted
user 23494
In set theory, the union (denoted by ∪) of a collection of sets is the set of all distinct elements in the collection. It is one of the fundamental operations through which sets can be combined and related to each other.
7
votes
1
answer
213
views
Getting the 'composite' of two polygon layers
;
CREATE TEMP TABLE b_table AS (
SELECT 'b1' as id, st_geomfromtext('POLYGON((40 40, 40 140, 140 140, 140 40, 40 40))') geom
UNION ALL
SELECT 'b2' as id, st_geomfromtext('POLYGON((30 30, … ALL
SELECT * FROM non_intersect_diff
UNION ALL
SELECT * FROM intersect_diff
UNION ALL
SELECT * FROM non_intersect_diff_reverse
UNION ALL
SELECT * FROM intersect_diff_reverse …
- 553