Revision 11161
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.sql | ||
|---|---|---|
| 827 | 827 |
CREATE FUNCTION locationevent__communities(locationevent_id integer) RETURNS SETOF text |
| 828 | 828 |
LANGUAGE sql STABLE |
| 829 | 829 |
AS $_$ |
| 830 |
SELECT commname.commname
|
|
| 830 |
SELECT commdescription
|
|
| 831 | 831 |
FROM commclass |
| 832 | 832 |
LEFT JOIN commdetermination USING (commclass_id) |
| 833 | 833 |
LEFT JOIN commconcept USING (commconcept_id) |
| 834 |
LEFT JOIN commname USING (commname_id) |
|
| 835 | 834 |
WHERE locationevent_id = $1 |
| 836 |
ORDER BY commname
|
|
| 835 |
ORDER BY commdescription
|
|
| 837 | 836 |
$_$; |
| 838 | 837 |
|
| 839 | 838 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: locationevent__communities(): need to use commdescription instead of commname as the communityName because that's where communityName has been mapped to in mappings/VegCore-VegBIEN.csv. (commname instead stores the communityID.)