> GREATEST() seems to use a simple compaire while MAX() > will use the default collating table. So during my web > searchs I can across a number of comments that MAX() > is not truly the same as GREATEST().
The real difference is that GREATEST is a scalar function while MAX is an aggregate function. I.e. GREATEST operates within a single row, MAX across rows. The Oracle 11g docs say that for GREATEST, they say it uses binary comparison unless you set NLS_COMP=LINGUISTIC. (You can still have binary comparison if you set NLS_SORT=BINARY, but then that's by conscious choice.) They don't talk about collation order for MAX. Maybe it's documented elsewhere. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
