Joel Burton wrote:
> re: structure of table C, I think you're misunderstand something
> about SERIALs. A SERIAL is just another name for an int that automatically
> has a sequence set up for it. So, if in table C, you want to store
> references to tables a and b, you want you schema to be:
[snip]
> note the use of INTs, not SERIALs.
You're right, thanks! I assumed that SERIAL was a special data
type like eg. Oracle NUMBER. Using INT4 now as FK and it works like
a charm, thanks again :)
Morten