From: Greg Patnude <gpatnude@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: User defined types -- Social Security number...
Date: Fri, 20 Feb 2004 18:31:00 -0800
Message-ID: <c16fu8$2ro4$1@news.hub.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gpatnude@hotmail.com
Subject: Re: User defined types -- Social Security number...
In-Reply-To: <c16fu8$2ro4$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox