[Zope] Oracle and MAX

Dan Rusch dgr427@gb.frontiernet.net
Tue, 28 Sep 1999 09:54:54 -0500


Has anyone used the sql MAX() with Oracle. We were using Sybase and
ported to Oracle and it seems that the MAX() in Oracle converts my real
numbers to integers this did not happen in Sybase, any thoughts? By the
way AVG() does the same

SELECT MAX("ItemNumber")
FROM SO_Items
WHERE "ServiceOrderID" = 1
AND "ItemNumber" < 2

The ItemNumber is a number(9,3) in the table SO_Items.

By the way the sql code works fine in sqlplus.