Madison Kelly <linux@xxxxxxxxxxx> writes: > Some people argue that gender is a spectrum. If you want to be very > inclusive. Maybe you could use a 'float' and stick with 0 = woman, 1 = man > (self documenting after all) with the option of '0.1 - 0.9' for people who > feel "in between". How efficient is 'float'? This would also work for animals > that fall outside then normal male/female designation. Then you can use NULL to represent unknown information but you miss the other possibility that was pointed out: the person refused to inform the gender. To cover all these possibilities with one single column we need a set of discrete states. -- Jorge Godoy <jgodoy@xxxxxxxxx>
