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