Ron Johnson wrote: > On 03/14/07 18:55, Ken Johanson wrote: > > In SQL servers in general, or in PG, is there a native field type > > to store fractions? Or must one resort to char or separate > > numerator/denominator columns? > > 1/3 repeats ad infinitum, and '1/3' would have to be converted to > 0.3333333333 before used in a computation, so: > > What's your ultimate purpose or goal?
His goal may be to store and compute rational numbers exactly. The answer is that there is no data type in PostgreSQL that supports this. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
