Re: Domain for numbers.
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 17 Jan 2008 09:45:20 -0400
Message-ID: <478f5bf4$0$4048$9a566e8b_at_news.aliant.net>
Date: Thu, 17 Jan 2008 09:45:20 -0400
Message-ID: <478f5bf4$0$4048$9a566e8b_at_news.aliant.net>
Naga lenoj 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).
If I recall correctly, postgresql has some support for regular expressions: http://www.postgresql.org/docs/8.1/static/functions-matching.html
Does it support general constraints with a CHECK keyword? Yes it does: http://www.postgresql.org/docs/8.1/static/ddl-constraints.html Received on Thu Jan 17 2008 - 14:45:20 CET