Re: Alter Table Column Datatype

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Christof Petig <christof(at)petig-baender(dot)de>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Alter Table Column Datatype
Date: 2003-09-29 15:02:47
Message-ID: 1064846886.60248.84.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A. On Mon, 2003-09-29 at 10:28, Christof Petig wrote:
> Rod Taylor schrieb:
> > Is this syntax ok?
> > ALTER TABLE <table> ALTER COLUMN <column> TYPE <new
> > type>
>
> shouldn't that be
> ALTER TABLE <table> ALTER [COLUMN] <column> [TYPE] <new type>
> which I clearly remember from different database systems.

I should be able to do that.

Thanks.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-29 15:04:55 Re: pg_dump bug in 7.4
Previous Message Hiroshi Inoue 2003-09-29 14:53:47 Re: pgsql-server/src/backend catalog/index.c comma ...