Am Donnerstag, 8. November 2007 schrieb Gregory Stark: > Shouldn't the cast be implicit anyways? What does having double precision > operators buy us? Wouldn't it introduce ambiguities?
Unless you use --enable-integer-datetimes, interval is stored as float internally, so historically, the selection of offered operators is correct. -- 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