Regular Expressions with SIMILAR TO

[FrankTheFox]

Hi,

I think i have a problem with SIMILAR TO.
This is my regular expression...

CREATE DOMAIN EMailAdr AS VARCHAR(255) NOT NULL
CONSTRAINT wrong_EMail
CHECK(VALUE SIMILAR TO '[A-Za-z]+[0-9]*(#|!|%|&|.)*@[a-z]+(-|.)*[a-z]*(-|.)*.[a-z]{2,3}');


I thought that curly bracktes are useful to make a repetition
m through n times. In this case the repetition goes 2 times through 3 times but it wont work.

I don't figure out where am i wrong.

Frank.

 

[ceco]

from

http://www.postgresql.org/docs/8.1/interactive/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP

it is written "Notice that bounded repetition (? and {...}) are not provided"

but why don't you use normal regular expression ~ (

http://www.postgresql.org/docs/8.1/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP)