check constraint

[mcvdmvs]

I have a simple question. Can i check a field in a db with a regular expression?
CREATE TABLE "links" (
"id" int primary key index NOT NULL,
"naam" varchar(32) NOT NULL,
"omschrijving" text NOT NULL,
"url" varchar(128) NOT NULL CHECK (^(

http://)?(

[0-9a-z]([-\\.]?[0-9a-z])*\\.)+[a-z]{2,}[0-9]+)?(/[-/.=_&0-9a-z]*)?(\\?[-.=_&0-9a-z]*)?$),
"regioid" int,
"brancheid" int NOT NULL,
"hits" int DEFAULT 0,
"prioriteit" int UNIQUE
); mcvdmvs
-- "It never hurts to help" -- Eek the Cat

 

[mcvdmvs]

Btw the answer is yes, and the above works. mcvdmvs
-- "It never hurts to help" -- Eek the Cat