Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE TODO items
Date
Msg-id 28068.1083900304@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Rod Taylor <pg@rbt.ca>)
Responses Re: ALTER TABLE TODO items  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: ALTER TABLE TODO items
Next
From: Rod Taylor
Date:
Subject: Re: ALTER TABLE TODO items