Re: [GENERAL] custom type for storing a HTML color

2007-03-27 Thread Kevin Hunter
On 27 Mar 2007 05:10p -0400, Justin Dearing wrote: > Hello, I currently store html color codes in that database with the > following DOMAIN: > > CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$'); > > Has anyone created a custom type that has additional functionality (eg > fo

[GENERAL] custom type for storing a HTML color

2007-03-27 Thread Justin Dearing
Hello, I currently store html color codes in that database with the following DOMAIN: CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$'); Has anyone created a custom type that has additional functionality (eg format the input or output to other formats, retrieve red, green o