Re: ALTER TABLE TODO items

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE TODO items
Date: 2004-05-07 03:25:04
Message-ID: 28068.1083900304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <pg(at)rbt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-05-07 03:33:55 Re: ALTER TABLE TODO items
Previous Message Rod Taylor 2004-05-07 03:21:08 Re: ALTER TABLE TODO items