Distinct + Limit

[Francois Deliege <fdeliege@xxxxxxxxx>]

Hi group,

I have the following table with millions of rows

CREATE TABLE table1
(
  col1 text,
col1 text,
  doc text
)

select col1 from table1 group by col1 limit 2;
select distinct on (col1) col1 from table1 limit 2;


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance