I've created a table, and index. Table = test +----------------------------+----------------------------+-------+ | Field | Type | Length| +----------------------------+----------------------------+-------+ | a | int4 | 4 | | c | varchar | 40 | +----------------------------+----------------------------+-------+ Index: _test_a if i need the max or min value of column a i can get with SELECT max(test.a); query. If i take look on the query tree: Aggregate (cost=43.00 rows=1000 width=4) -> Seq Scan on test (cost=43.00 rows=1000 width=4) ... Ok, i understand: all type of the aggregates work on same way, but... have i any chance to get extrem values, without seq scan? Thanx in advice -- nek;( ************
