Revision 12515
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 673 | 673 |
|
| 674 | 674 |
|
| 675 | 675 |
-- |
| 676 |
-- Name: FUNCTION source_by_shortname(shortname varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: - |
|
| 677 |
-- |
|
| 678 |
|
|
| 679 |
|
|
| 680 |
|
|
| 681 |
|
|
| 682 |
-- |
|
| 676 | 683 |
-- Name: sourcename_set_matched_source_id(); Type: FUNCTION; Schema: public; Owner: - |
| 677 | 684 |
-- |
| 678 | 685 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1479 | 1479 |
|
| 1480 | 1480 |
|
| 1481 | 1481 |
-- |
| 1482 |
-- Name: FUNCTION source_by_shortname(shortname text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: - |
|
| 1483 |
-- |
|
| 1484 |
|
|
| 1485 |
COMMENT ON FUNCTION source_by_shortname(shortname text, schema_anchor anyelement) IS ' |
|
| 1486 |
usage: |
|
| 1487 |
SELECT (SELECT public.source_by_shortname(''datasource'')) AS source_id;
|
|
| 1488 |
/* *must* be run as a nested SELECT, because otherwise Postgres apparently will |
|
| 1489 |
not inline it. not inlining causes the query to be run for *each* row in a table |
|
| 1490 |
of potentially millions, and creates a significant slowdown (eg. >1.5 hours for |
|
| 1491 |
SALVIAS._plots_06_list_of_plots_with_stem_measurements) */ |
|
| 1492 |
'; |
|
| 1493 |
|
|
| 1494 |
|
|
| 1495 |
-- |
|
| 1482 | 1496 |
-- Name: sourcename_set_matched_source_id(); Type: FUNCTION; Schema: public; Owner: - |
| 1483 | 1497 |
-- |
| 1484 | 1498 |
|
Also available in: Unified diff
schemas/vegbien.sql: source_by_shortname(): documented that it must be run as a nested SELECT, because otherwise Postgres will not inline it. not inlining causes the query to be run for each row in a table of potentially millions, and creates a significant slowdown (eg. >1.5 hours for SALVIAS._plots_06_list_of_plots_with_stem_measurements)