On Fri, 2009-07-10 at 18:47 +0100, Greg Stark wrote: > > -- foo has a primary key > Well no, it's equivalent to SELECT DISTINCT * FROM foo; I think you missed that "foo" has a primary key. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general