hi,
Is it possible in Postgre to have enum type, so that later table fileld get values from 1-6 (saving space)
1 - statex2 - stateY3 - stateZ
something like that and then constrain on this enum type..
tia