Rod Taylor <[EMAIL PROTECTED]> 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
---------------------------(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
