Revision 11099
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 415 | 415 |
|
| 416 | 416 |
|
| 417 | 417 |
-- |
| 418 |
-- Name: locationevent__contributors(int(11)); Type: FUNCTION; Schema: public; Owner: - |
|
| 419 |
-- |
|
| 420 |
|
|
| 421 |
|
|
| 422 |
|
|
| 423 |
|
|
| 424 |
-- |
|
| 418 | 425 |
-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: - |
| 419 | 426 |
-- |
| 420 | 427 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 821 | 821 |
|
| 822 | 822 |
|
| 823 | 823 |
-- |
| 824 |
-- Name: locationevent__contributors(integer); Type: FUNCTION; Schema: public; Owner: - |
|
| 825 |
-- |
|
| 826 |
|
|
| 827 |
CREATE FUNCTION locationevent__contributors(locationevent_id integer) RETURNS text[] |
|
| 828 |
LANGUAGE sql STABLE |
|
| 829 |
AS $_$ |
|
| 830 |
SELECT array_agg(fullname) |
|
| 831 |
FROM locationeventcontributor |
|
| 832 |
LEFT JOIN party USING (party_id) |
|
| 833 |
WHERE locationevent_id = $1 |
|
| 834 |
$_$; |
|
| 835 |
|
|
| 836 |
|
|
| 837 |
-- |
|
| 824 | 838 |
-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: - |
| 825 | 839 |
-- |
| 826 | 840 |
|
Also available in: Unified diff
schemas/vegbien.sql: added locationevent__contributors() aggregating function for use in analytical_stem_view