From: Naga lenoj <nagalenoj_at_gmail.com>
Date: Thu, 17 Jan 2008 04:20:58 -0800 (PST)
Message-ID: <35863c3b-d110-4605-831a-cff21b6ee1f6_at_d21g2000prf.googlegroups.com>
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,
I am using postgresql(for your information). Received on Thu Jan 17 2008 - 13:20:58 CET
Date: Thu, 17 Jan 2008 04:20:58 -0800 (PST)
Message-ID: <35863c3b-d110-4605-831a-cff21b6ee1f6_at_d21g2000prf.googlegroups.com>
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). Received on Thu Jan 17 2008 - 13:20:58 CET