Re: [GENERAL] Can one alter the format of a numeric column?

2004-11-27 Thread Chris Green
On Sat, Nov 27, 2004 at 10:50:47AM -0700, Michael Fuhr wrote: > On Sat, Nov 27, 2004 at 05:29:42PM +, 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

Re: [GENERAL] Can one alter the format of a numeric column?

2004-11-27 Thread Michael Fuhr
On Sat, Nov 27, 2004 at 05:29:42PM +, 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

[GENERAL] Can one alter the format of a numeric column?

2004-11-27 Thread Chris Green
Can one alter the precision of a numeric column? I want to reduce the precision of a column from 20,4 to 20,2. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)---