What do you want to change it to? Another number? Use something like Update table set field = field + 1
I assume you are going to store the result in the same table column? On Mon, 2004-07-12 at 13:07, [EMAIL PROTECTED] wrote: > I have a int4 coloumn, and I want to change the last bit the the > number in this column to 0. How can I do it? > > Thanks, > > John > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html