(10 rows)

-- Aggregate function

SELECT SUM(c_bigint), MAX(c_text), MIN(c_text) FROM T;

SELECT SUM(c_bigint), MAX(c_text COLLATE "C"), MIN(c_text COLLATE "C") FROM T;

sum | max | min

-----+-------+-----

200 | hello | 31

ORDER BY pkLIMIT10;

SELECTSUM(c_bigint),MAX(c_text),MIN(c_text)FROM T;

SELECTSUM(c_bigint),MAX(c_text COLLATE"C"),MIN(c_text COLLATE"C")FROM T;

SELECT*FROM TORDER BY c_bigint, c_text, pkLIMIT10;