On Thu, Jun 19, 2008 at 03:38:28PM -0400, blackwater dev wrote: > The problem is name is not one column but made up of firstname, > lastname...how do I do this?
I'd probably do something like: SELECT firstname, lastname, COUNT(*) FROM people GROUP BY firstname, lastname HAVING COUNT(*) > 1; Sam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general