Yeap,
Tx Brett. The syntaxe you gave means much more to me than the one I got
from the Book "PostresSQL : Introduction & Concept" from Bruce Momjian
seems a bit short while the PostgreSQL user guide from Thomas LOCKHART
has the full theorical description.
I'll probably stick more with the second one in the future.
Thomas,
>
> You mean as a foreign key? You would do something like
>
> create table books_authors (
> book integer references book(book_pk)
> on delete no action,
> author integer references author(author_pk)
> on delete no action,
> ...
> );
>
> This forces integrity between the tables so the only allowable values in
> the books_authors table are those values in the referenced fields (foreign
> keys).
>
> You will probably want to look up the documentation on contraints and
> foreign keys (I believe they are under the CREATE TABLE documentation).
>
--
Sat Dec 30 15:23:42 CET 2000
Thomas SMETS e-mail : tsmets@altern.org
Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94.
1030 Bruxelles
======= Quote of the Day =========
"In the long run, every program becomes rococo, and then rubble."
-- Alan Perlis
========= End of Quote ===========