Revision 12183
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 5252 | 5252 |
CREATE VIEW _06_list_of_plots_with_stem_measurements AS |
| 5253 | 5253 |
SELECT top_plot.authorlocationcode |
| 5254 | 5254 |
FROM public.top_plot |
| 5255 |
WHERE ((top_plot.source_id = public.source_by_shortname(("current_schema"())::text)) AND (EXISTS ( SELECT NULL::unknown
|
|
| 5255 |
WHERE ((top_plot.source_id = public.source_by_shortname(("current_schema"())::text)) AND (EXISTS ( SELECT NULL::unknown AS unknown
|
|
| 5256 | 5256 |
FROM (((((public.location |
| 5257 | 5257 |
JOIN public.locationevent USING (location_id)) |
| 5258 | 5258 |
JOIN public.taxonoccurrence USING (locationevent_id)) |
Also available in: Unified diff
schemas/vegbien.sql: regenerated from DB, which adds an autogenerated column alias