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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly