user account uniqueness

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: user account uniqueness
Date: 2003-02-07 18:59:22
Message-ID: IGFC604ROQLZX3V63POZT2XFAE976QO.3e44020a@cal-lab
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Mikhail Terekhov 2003-02-07 19:27:23 Re: How to make a dictoinary list of a query result
Previous Message greg 2003-02-07 18:55:47 Re: selects with large offset really slow