Обсуждение: Can one alter the format of a numeric column?

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 (chris@areti.co.uk)

    "Never ascribe to malice, that which can be explained by incompetence."

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/

On Sat, Nov 27, 2004 at 10:50:47AM -0700, Michael Fuhr wrote:
> 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
>
OK, thanks.  That means I need to dump the data and re-import it.
Or, no, I can use an UPDATE to do it I guess.

--
Chris Green (chris@areti.co.uk)

    "Never ascribe to malice, that which can be explained by incompetence."