[EMAIL PROTECTED] writes: > Return datatype of the floor function is different between PostgreSQL 7.2 and >PostgreSQL 7.3 the documentation for PostgreSQL 7.3 states that PostgreSQL 7.3's >floor function should return type numeric. In 7.3 it seems to be returning the double >precision datatype. Oracle 8.0.5 correctly executes the test statments along with >PostgreSQL 7.2. (we have to be compatible)
> The documentation mentioned: > http://www.postgresql.org/docs/view.php?version=7.3&file=functions-math.html This table seems not to have been updated when we added float versions of ceil(), floor(), and sign(). You won't get any support for ripping them out again, though. I suggest adding casts to the queries, or possibly defining a version of mod() that takes float8. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
