Re: Dumb question about serial's upper limit - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Dumb question about serial's upper limit
Date
Msg-id 592FF5A8-F42D-47B6-BB1C-978DF01A40F6@myrealbox.com
Whole thread Raw
In response to Re: Dumb question about serial's upper limit  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
On Oct 11, 2005, at 14:04 , CSN wrote:

> I was thinking about the types in the C code behind
> PostgreSQL, rather than types in PG itself. Been a
> long time since I coded in C but I thought it had
> unsigned ints and maybe data types could be mapped as
> so (pardon my ignorance about C/PG's inner workings):
>
> PG int => C signed int
> PG serial => C unsigned int

Serial is not a datatype per se; it's essentially a macro to create a
sequence (foo_seq) and an INT column that has a default value of
nextval('foo_seq').

Michael Glaesemann
grzm myrealbox com




pgsql-general by date:

Previous
From: Gregory Wood
Date:
Subject: Re: Oracle buys Innobase
Next
From: Sim Zacks
Date:
Subject: Re: strange error