Revision 6086
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 333 | 333 |
|
| 334 | 334 |
|
| 335 | 335 |
-- |
| 336 |
-- Name: reference_by_shortname(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 337 |
-- |
|
| 338 |
|
|
| 339 |
|
|
| 340 |
|
|
| 341 |
|
|
| 342 |
-- |
|
| 336 | 343 |
-- Name: sync_analytical_aggregate_to_view(); Type: FUNCTION; Schema: public; Owner: - |
| 337 | 344 |
-- |
| 338 | 345 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added reference_by_shortname(). Using this function instead of the manual query should force the query planner to evaluate this expression first, rather than complexly reordering joins to place this nested select as a filter condition.