root/trunk/inputs/.IRMNG/genus_homonym_epithet/create.sql
| 1 |
SELECT "taxonNameOrEpithet" |
|---|---|
| 2 |
FROM genus_homonyms |
| 3 |
GROUP BY "taxonNameOrEpithet" |
| 4 |
HAVING NOT util.all_same(kingdom) -- not internal Plantae homonyms |
| 5 |
;
|
| 6 |
|
| 7 |
ALTER TABLE :table ADD PRIMARY KEY ("taxonNameOrEpithet"); |