constraint expression

Поиск
Список
Период
Сортировка
Искать
От
2004@niederland.com (Roger Niederland)
Тема
constraint expression
Дата
Msg-id
89683d03.0408061714.4ed01320@posting.google.com
Список
Дерево обсуждения
constraint expression 2004@niederland.com (Roger Niederland)
Re: constraint expression Kris Jurka <books@ejurka.com>
Hello,

I am having problems adding a simple expression to a table level
constraint.
Here is an example of one which postgresql 7.4.3 does not accept.

create table test (a int, b int, c int, 
constraint aname check (((a=0) and (b is not null)) or ((a=1) and (c
is not null)));

Should this work?  It is complaining 'ERROR:  syntax error at or near
";" at character 126'

Thanks
В списке pgsql-general по дате отправления
От: Chris Travers
Дата:
От: Thiemo Kellner
Дата:
FAQ