On Jan 17, 1:25 pm, Naga <nagale...@[EMAIL PROTECTED]
> wrote:
> Actually, i have a need to store the numbers like "AS2303",
> TS3381"(first 2 alphabets,next 3 numbers). What i want is, i have to
> assign the integrity which can check the following values,
> 23334, ASDER, SDE23, 233A4 and like this.
> If i assign as a character type domain.Then i can't check the above
> cases.
> Can anyone help me?
> I am using postgresql(for your information).
http://joseph.randomnetworks.com/archives/2004/05/24/postgresql-check-constraint-sup****ts-regular-expressions/
HTH
/Lennart
|
