On Wed, 20 Jun 2001, Gregory Youngblood wrote: > I have an ID column which is a bigint, and I have another ID column which was > created using SERIAL, so it is an integer. > > Is it possible to use SERIAL to get a int8 datatype instead int (int4)? Not as far as I know, but there is talk to actually make it int8 in the future. > > Finally, is it possible to get unsigned integer data types in a table? No. cheers, thalis > > Thanks, > Greg > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl