Problem with a Pettern Matching Check

Поиск
Список
Период
Сортировка
От Sebastian Siewior
Тема Problem with a Pettern Matching Check
Дата
Msg-id 20050816001950.2225e5b8@mikejones.ghb.fh-furtwangen.de
обсуждение исходный текст
Ответы Re: Problem with a Pettern Matching Check  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Re: Problem with a Pettern Matching Check  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-sql
Hello hopefully correct List,

I was trying to do something that is not working as it supposed to.
First I created a table:

create table t ( col CHAR (3) CONSTRAINT numonly_col CHECK ( col ~ '^\\d+$' ) 
);

This check avoids non-numbers like '1a1' and allows '123'. For some
reason, I'm unable to find out why, it also avoids things like '1' and
'12'. Could someone please give me hint? :)

I was trying this one on PostgreSQL 8.0.3

-- 
Regards
Sebastian Siewior


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: sql function: using set as argument
Следующее
От: "Dmitri Bichko"
Дата:
Сообщение: Re: Problem with a Pettern Matching Check