Rod Taylor <pg@rbt.ca> writes:
>>> Also, should the syntax be SET TYPE, not just TYPE?
>> Shrug ... I dunno whether Rod had a precedent for that choice or not.
> FireBird: ALTER COLUMN <column> TYPE <type>
> DB2: ALTER COLUMN <column> SET DATA TYPE <type>.
> Oracle: MODIFY <column> <type>
> MSSQL: ALTER COLUMN <column> <type> <constraints>
> MySQL: Both Oracle and MSSQL
> Sap: MODIFY <column> <type>
Given that, I'm happy with what we got ...
regards, tom lane