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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can one alter the format of a numeric column?
Date: 2004-11-27 17:50:47
Message-ID: 20041127175047.GB7610@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-27 17:58:36 Re: row-level deadlock problem
Previous Message Chris Green 2004-11-27 17:29:42 Can one alter the format of a numeric column?