try:
select tax_code from warehouse.sec_trans group by tax_code
there was a discussion about this on the pgsql-performance a while back:
http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php
-ae
On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote:
select DISTINCT tax_code from warehouse.sec_trans We let this run
for 1/2 hour or so and canceled it.
Then I tried select DISTINCT ON (tax_code) tax_code from
warehouse.sec_trans
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org