Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
custom type for storing a HTML color
- From: "Justin Dearing" <zippy1981(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: custom type for storing a HTML color
- Date: Tue, 27 Mar 2007 17:10:59 -0400
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 or
blue values as 0-255 integers, etc. This is good enough for my uses at
the moment, but has anyone invented a better wheel than mine?
- Follow-Ups:
- Re: custom type for storing a HTML color
- From: Kevin Hunter
- Re: custom type for storing a HTML color
- Prev by Date: Re: Is there a shortage of postgresql skilled ops people
- Next by Date: Re: multi-row check constraints?
- Previous by thread: redhat debug info
- Next by thread: Re: custom type for storing a HTML color
- Indexes: