On Sat, Nov 27, 2004 at 05:29:42PM +0000, Chris Green wrote: > Can one alter the precision of a numeric column? > > I want to reduce the precision of a column from 20,4 to 20,2.
In PostgreSQL 8.0 (currently in beta) you can use ALTER TABLE to alter a column's type. For previous versions see the FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.4 -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
