Revision 10627
Added by Aaron Marcuse-Kubitza over 11 years ago
| create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 1 |
SELECT DISTINCT ON (observation_id) *
|
|
| 2 | 2 |
FROM observation |
| 3 | 3 |
LEFT JOIN soilobs USING (observation_id) |
| 4 |
ORDER BY observation_id, soilobs_id |
|
Also available in: Unified diff
bugfix: inputs/VegBank/observation_/create.sql: ensure only one row per observation by selecting the first soilobs for each observation