user account uniqueness - Mailing list pgsql-general

From Dennis Gearon
Subject user account uniqueness
Date
Msg-id IGFC604ROQLZX3V63POZT2XFAE976QO.3e44020a@cal-lab
Whole thread Raw
List pgsql-general
I have a site I'm building that can have the following types of users:

    Those that have email accounts
    Those that don't.

I collect address information, phone numbers, full names, (all normalized at this point)

    I can't collect:

        credit card info
        driver's license numbers
        blood type :-)

How can I assure uniqueness and non duplication of users if I keep all the users in the same table?





pgsql-general by date:

Previous
From: sanjay2kind@yahoo.com (sanjay)
Date:
Subject: Need help for converting query result to list of dictoinary
Next
From: greg@turnstep.com
Date:
Subject: Re: selects with large offset really slow