I'd like the ability to get the greatest or least number in a parameterized list, like:

select Greatest(col1,col2,col3,col3)  / Least(col1,col2,col3,col4);

See:
http://dev.mysql.com/doc/refman/5.6/en/comparison-operators.html

Barry

Barry


Personally I'd prefer the ability to pass an untyped array into a function / procedure and the ability to detect type inside the function and loop round the values. Then I could write GREATEST & LEAST and a load of other stuff myself.

Roy Lambert

+1

When wishing, wish big.

Barry

Barry,

<< I'd like the ability to get the greatest or least number in a
parameterized list, like:

select Greatest(col1,col2,col3,col3)  / Least(col1,col2,col3,col4); >>

Noted.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com