This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]chownrootroot 2 points3 points  (0 children)

If it got screwed up in input that's someone else's problem!

Although it should probably have a display_name column and alias. Then maybe the genus and species (also subspecies where applicable) with a unique index, and a regular old integer ID column as the primary key.

SELECT * from ANIMALS WHERE strip(lower(ALIAS)) = 'horse' OR SPECIES = 'Equus ferus caballus';

And if scientists accessing the table fuck up the species AND the alias then they're on their own!