References to SERIAL - Mailing list pgsql-sql

From Thomas SMETS
Subject References to SERIAL
Date
Msg-id 3A4E0FC4.4D9EB1F8@altern.org
Whole thread Raw
Responses Re: References to SERIAL
List pgsql-sql
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
);

create table books_authors (
??? // I want to reference the book pk & the author pk to be able to
make the X-ref ?
);

tx,

THomas










-- 
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 ===========


pgsql-sql by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: Date/Time problem -(((
Next
From: "Albert REINER"
Date:
Subject: PL/pgSQL: returning array?