Re: User defined types -- Social Security number... - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: User defined types -- Social Security number...
Date
Msg-id 200402281618.i1SGIrp28893@candle.pha.pa.us
Whole thread Raw
In response to Re: User defined types -- Social Security number...  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Josh Berkus wrote:
> Greg,
> 
> > Anyone have a good pre-built user-defined type definition for creating /
> > maintaining / manipulating a SSN ... where valid chars are in the range
> > 000-00-0000 through 999-99-9999.
> 
> Actually, the range is more narrowly defined than that.  I'm not sure of the 
> exact rules, but you will never see a leading 0 or a -00- in an SSN.

Actually I know someone who's SSN starts as 003.

Agreed on the DOMAIN suggestion.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Convert INT to INTERVAL?
Next
From: "Sumita Biswas"
Date:
Subject: Input Arguments