Re: [HACKERS] Alter Table Column Datatype

[Christof Petig]

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match