Re: filtering out doubles with SELECT - Mailing list pgsql-novice

> On Wed, Mar 12, 2003 at 12:11:05 +0100,
>   Jules Alberts <jules.alberts@arbodienst-limburg.nl> wrote:
> >
> > select * from tbl t1 where not exists (select * from tbl t2 where
> > t1.COL1=t2.COL1 and t1.COL2=t2.COL2 and t1.oid <> t2.oid)
>
> Using DISTINCT ON might be faster (though it's nonstandard).

Thanks, I didn't know that one!