constraint function, newbie

Поиск
Список
Период
Сортировка
От Michal Adamczak
Тема constraint function, newbie
Дата
Msg-id pan.2003.03.21.11.28.22.20813@druid.if.uj.edu.pl
обсуждение исходный текст
Список pgsql-general
hi
i am learning postgres and made a library model

i dont want a user to be able to borrow 2 items (copies)
of the same book so made a function to check it (below)

the function works fine but now i would like to add a constraint,
unfortunatelly i fail

here's my try:

create function bookborrow_check_insert
(bookborrow.userid%TYPE, bookborrow.bookitem_id%TYPE)
returns bool as
'select NOT $1 in (select userid from bookborrow where userid = $1 and
bookitem_id = $2 and returned is null)'
 language sql;

=> alter table bookborrow add check(bookborrow_check_insert (userid, bookitem_id));
ERROR:  AlterTableAddConstraint: rejected due to CHECK constraint <unnamed>

=> alter table bookborrow add  constraint check_insert check(bookborrow_check_insert (userid, bookitem_id));
ERROR:  AlterTableAddConstraint: rejected due to CHECK constraint check_insert

--
Michal Adamczak
pokryfka @ druid.if.uj.edu.pl
GS dpu C+++ UL+++++ L+++(++++) w--- !tv h*
I code AND I bathe. (seen on slashdot)


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: [HACKERS] Extracting time from timestamp
Следующее
От: "Anand B Kumar"
Дата:
Сообщение: Please clarify with regard to Renaming a Sequence