How to add month.year column validation

Поиск
Список
Период
Сортировка
Искать
От
Andrus
Тема
How to add month.year column validation
Дата
Msg-id
94B87F34244142548ABE27C8A81BC354@andrusnotebook
Список
Дерево обсуждения
How to add month.year column validation "Andrus" <kobruleht2@hot.ee>
Re: How to add month.year column validation Michael Glaesemann <grzm@seespotcode.net>
Re: How to add month.year column validation "Andrus" <kobruleht2@hot.ee>
Re: How to add month.year column validation "Dann Corbit" <DCorbit@connx.com>
Re: How to add month.year column validation "Andrus" <kobruleht2@hot.ee>
Re: How to add month.year column validation Andy Shellam <andy-lists@networkmail.eu>
Re: How to add month.year column validation Scott Marlowe <scott.marlowe@gmail.com>
Re: How to add month.year column validation "Andrus" <kobruleht2@hot.ee>
Re: How to add month.year column validation Adrian Klaver <aklaver@comcast.net>
Re: How to add month.year column validation Scott Marlowe <scott.marlowe@gmail.com>
Re: How to add month.year column validation Scott Marlowe <scott.marlowe@gmail.com>
Re: How to add month.year column validation Michael Glaesemann <grzm@seespotcode.net>
Re: How to add month.year column validation Andy Shellam <andy-lists@networkmail.eu>
Re: How to add month.year column validation "Dann Corbit" <DCorbit@connx.com>
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 по дате отправления
От: Andrew Crouch
Дата:
От: Andy Shellam
Дата:
FAQ