On Tue, April 19, 2005 11:55 am, Hank said:
> Except that the zip code field is not (and should not be) numeric, so
> the qualification test fails.
*IF* your zip codes are all US zip 5-digit, and
*IF* performance is really crucial, and
*IF* you are 100% certain you'll never need non-US nor zip+4, and
*IF* MySQL int optimization proved *much* faster...
I could see a valid argument for making the zip field int.
That's a hell of a lot of IFs, and I'm willing to bet that it will bite
you in the butt one day, because you were *wrong* about never needing
internation or zip+4, but there it is.