I added the CREATE INDEX statement in the below citext regression tests, since it seemed to have been omitted by accident:
-- Test aggregate functions and sort ordering CREATE TEMP TABLE srt ( name CITEXT ); INSERT INTO srt (name) VALUES ('aardvark'), ('AAA'), ('aba'), ('ABC'), ('abd'); CREATE INDEX srt_name ON srt (name); -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; SELECT MAX(name) AS abd FROM srt; reset enable_seqscan; set enable_indexscan = off; SELECT MIN(name) AS "AAA" FROM srt; SELECT MAX(name) AS abd FROM srt; reset enable_indexscan; -- Check sorting likewise set enable_seqscan = off; SELECT name FROM srt ORDER BY name; reset enable_seqscan; set enable_indexscan = off; SELECT name FROM srt ORDER BY name; reset enable_indexscan; -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers