Re: [SQL] References to SERIAL

2000-12-30 Thread Thomas SMETS
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 seco

Re: [SQL] References to SERIAL

2000-12-30 Thread Oliver Elphick
"Brett W. McCoy" wrote: >On Sat, 30 Dec 2000, Thomas SMETS wrote: > >> If i create a "internal pk" buy defining on a table a field SERIAL. >> How do I reference this field in the other table to set the field >> possible value ? ... > >You mean as a foreign key? You would do somethi

Re: [SQL] References to SERIAL

2000-12-30 Thread Brett W. McCoy
On Sat, 30 Dec 2000, Thomas SMETS wrote: > If i create a "internal pk" buy defining on a table a field SERIAL. > How do I reference this field in the other table to set the field > possible value ? > > > create table book ( > /* This is an internal primary key for the book description */ >

[SQL] References to SERIAL

2000-12-30 Thread Thomas SMETS
Hi, If i create a "internal pk" buy defining on a table a field SERIAL. How do I reference this field in the other table to set the field possible value ? create table book ( /* This is an internal primary key for the book description */ book_pk serial, // End of Book def )