totally random sql question - using postgresql, is...

# exposed

[talios]

totally random sql question - using postgresql, is there a good/optimal/fast column data type one could use for keyword/code based index/joins, rather than a numeric ID, I want to join on a code such as SERVICE or TRIAL or SALES_TAX - almost like a enum, but that can easily be runtime generated ( enums being more fixed structure )