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).