1,Greatest (n1,n2,n3,..........) Get maximum value
Testdb= #SELECT Greatest (3,5,1,8, -, About, the, -, the, +); +---------------------------------------------------------+ | Greatest (3,5,1,8, -, About, the, -, the, +) | +---------------------------------------------------------+ | About| +---------------------------------------------------------+1Rowinch Set(0.00Sec
2,LEAST (n1,n2,n3,n4,......) get the minimum value
testdb= #SELECT LEAST (3,5,1,8, -, About, the, -, the, +); +---------------------------------------------------------+ | LEAST (3,5,1,8, -, About, the, -, the, +) | +---------------------------------------------------------+ |1| +---------------------------------------------------------+1Rowinch Set(0.00Sec
Other more function references: http://developer.51cto.com/art/201401/426252_all.htm
The PostgreSQL function gets the numeric size value of multiple fields