Re:

"Alexei A.Romanenko" <A(dot)A(dot)Romanenko(at)inp(dot)nsk(dot)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