How to add month.year column validation - Mailing list pgsql-general

From Andrus
Subject How to add month.year column validation
Date
Msg-id 94B87F34244142548ABE27C8A81BC354@andrusnotebook
Whole thread Raw
Responses Re: How to add month.year column validation  (Andy Shellam <andy-lists@networkmail.eu>)
Re: How to add month.year column validation  (Michael Glaesemann <grzm@seespotcode.net>)
Re: How to add month.year column validation  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
Database contains CHAR(7) type column which must be NOT NULL and must be in
the format

mm.yyyy

where:

mm - month number, always two digits in range 01 .. 12

. - separator  must be point always.

yyyy - must be four digits in range approx. 1980 .. 2110 .

How to add column validation to table column which forces this ?

Andrus.


pgsql-general by date:

Previous
From: Andrew Crouch
Date:
Subject: Re: Archive command seem to be working.
Next
From: Andy Shellam
Date:
Subject: Re: How to add month.year column validation