Horton
Menu

Re: Alter Table Column Datatype

Christof Petig <christof@petig-baender.de>

View thread
From: Christof Petig <christof@petig-baender.de>
To: Rod Taylor <rbt@rbt.ca>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-09-29T14:28:41Z
Lists: pgsql-hackers 
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.

     Christof