On Apr 28, 2011, at 3:22 PM, Dmitriy Igrishin wrote:
> NB: I am sure that OP is not sure :-) And since foo.bar is varchar, > it is better to use numeric instead of float :-)
Now, this make to ask question, why numeric? How its better than float?
Only one point, Vibhor. I believe that varchar data type was chosen for exact storage of numeric values. According to chapter 8.1.3 of the doc. for this case the usage of numeric is preferred over floating data types.