Revision 7110
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1031 | 1031 |
WHERE taxondetermination_id = ( |
| 1032 | 1032 |
SELECT taxondetermination_id FROM taxondetermination |
| 1033 | 1033 |
WHERE taxonoccurrence_id = new.taxonoccurrence_id |
| 1034 |
ORDER BY isoriginal/*false first*/, determinationdate DESC NULLS LAST |
|
| 1034 |
ORDER BY |
|
| 1035 |
-- Scrubbed determinations must come first for scrub.make to work |
|
| 1036 |
COALESCE(determinationtype = 'computer', false) DESC/*true first*/ |
|
| 1037 |
, isoriginal/*false first*/ |
|
| 1038 |
, determinationdate DESC NULLS LAST |
|
| 1035 | 1039 |
LIMIT 1 |
| 1036 | 1040 |
); |
| 1037 | 1041 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination_set_iscurrent(): Fixed bug where need to sort scrubbed determinations first for scrub.make to work. (Otherwise, a datasource determination might remain iscurrent even after a scrubbed determination was added, causing scrub.make to repeatedly attempt to re-add it.)