Re:

"Alexei A.Romanenko" <A.A.Romanenko@inp.nsk.su> writes:
> It seems to me there is a problem with regular expressions.
> When i create table and try to insert some restriction for
> a fields, system accept it. Then, whem i insert something, which
> dont match to regexp, it inserted anyway or backwards.

No bug there.  You've forgotten that a char(N) field value will be
space-padded to N characters.  For variable-length strings you
ought to be using varchar(N) instead.  If you really want to use
char(N), you can match with regexps like 'foo *$'.

            regards, tom lane