Project

General

Profile

1
SELECT "taxonNameOrEpithet"
2
FROM family_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");
(4-4/8)