On Thu, Aug 28, 2003 at 21:10:19 +0530, Shridhar Daithankar <[EMAIL PROTECTED]> wrote: > > Actually I have no idea if you can insert specific value in a serial field. I > wouldn't be surprised if it works as intended but don't have a postgresql > installation handy here. (Working in windows right now..)
Yes you can. Serial types are implemented using a default that gets a value from a corresponding sequence. If you specify a value while inserting the default won't get used. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend