 | |
#1
 
| |||
| |||
|
Domain for numbers. -
01-17-2008
, 07:25 AM
#2
| |||
| |||
|
|
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/arc...r-expressions/
HTH
/Lennart
#3
| |||
| |||
|
|
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/arc...r-expressions/
HTH
/Lennart
#4
| |||
| |||
|
|
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/arc...r-expressions/
HTH
/Lennart
#5
| |||
| |||
|
|
On Jan 17, 1:25 pm, Naga <nagale... (AT) gmail (DOT) com> 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/arc...stgresql-check... HTH /Lennart |
enterprises, which is a scientific research center and big company of
flower production. It has a planting area of over 165 acres. We mainly
engaged in the cultivation, breeding and production of the Roses.
Every year 7 million Rose seedlings are produced in our research
center.
If you are interested in our roses, please browse here:
http://www.nyrose.cn/English/index.asp
#6
| |||
| |||
|
|
On Jan 17, 1:25 pm, Naga <nagale... (AT) gmail (DOT) com> 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/arc...stgresql-check... HTH /Lennart |
enterprises, which is a scientific research center and big company of
flower production. It has a planting area of over 165 acres. We mainly
engaged in the cultivation, breeding and production of the Roses.
Every year 7 million Rose seedlings are produced in our research
center.
If you are interested in our roses, please browse here:
http://www.nyrose.cn/English/index.asp
#7
| |||
| |||
|
|
On Jan 17, 1:25 pm, Naga <nagale... (AT) gmail (DOT) com> 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/arc...stgresql-check... HTH /Lennart |
enterprises, which is a scientific research center and big company of
flower production. It has a planting area of over 165 acres. We mainly
engaged in the cultivation, breeding and production of the Roses.
Every year 7 million Rose seedlings are produced in our research
center.
If you are interested in our roses, please browse here:
http://www.nyrose.cn/English/index.asp
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.