User defined types -- Social Security number...

From: "Greg Patnude" <gpatnude(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: User defined types -- Social Security number...
Date: 2004-02-21 02:31:00
Message-ID: c16fu8$2ro4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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.

I imagine that the storage column is probably varchar(11) -- I am looking
for a type definition that

1) checks that all numbers are in the range [0..9]
2) inserts the dashes at position
3) accepts either '000123456' OR '000-12-3456' as the input
4) leading zeroes (as in the above) must be stored -- hence varchar(11)
instead of numeric
5) always outputs in thje format '000-12-3456'

Either that or the question is: How can I coerce postgreSQL into using an
input / output "mask"...

--
Greg Patnude / The Digital Demention
2916 East Upper Hayden Lake Road
Hayden Lake, ID 83835
(208) 762-0762

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Scott Goodwin 2004-02-21 04:34:37 Mac OS X, PostgreSQL, PL/Tcl
Previous Message Nicolai Tufar 2004-02-21 02:23:17 Re: 7.4.1 release status - Turkish Locale

Browse pgsql-sql by date

  From Date Subject
Next Message V i s h a l Kashyap @ [Sai Hertz And Control Systems] 2004-02-21 08:12:22 Re: Function
Previous Message scott.marlowe 2004-02-20 21:18:03 Re: Date Foo.