Thread: referencing serials

referencing serials

From
Markus Wagner
Date:
Hello,

which data type should be used to hold references to SERIALs in external
tables?

I tried to use SERIAL, but then a sequence is created for the
referencing table.

Markus



Re: referencing serials

From
"Emils Klotins"
Date:
On 21 Jul 2000, at 9:41, Markus Wagner wrote:

> which data type should be used to hold references to SERIALs in 
external
> tables?
integer I believe.
Actually if you \d a table with a serial you'll see that it's an integer 
with DEFAULT clause specified.