Revision 13927
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2211 | 2211 |
AS $_$ |
| 2212 | 2212 |
/* use function rather than operator+search_path to allow inlining, which |
| 2213 | 2213 |
enables util.south_america() to only be evaluated once */ |
| 2214 |
SELECT util.contained_within__no_dateline($1, util.south_america())
|
|
| 2214 |
SELECT $1.latitude_deg BETWEEN -56 AND 13 AND $1.longitude_deg BETWEEN -82 AND -34
|
|
| 2215 | 2215 |
$_$; |
| 2216 | 2216 |
|
| 2217 | 2217 |
|
Also available in: Unified diff
schemas/util.sql: in_south_america(): optimized by using BETWEEN instead of util.contained_within__no_dateline(). this reduces the filter time for 2014-6-4.Iara_Lacher.reserve_prioritization by about 10%.