Re: changing the nulability of columns

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: changing the nulability of columns
Date: 2002-02-16 04:35:39
Message-ID: 200202160436.g1G4aAS14964@neuromancer.ctlno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> So, the question is - what the heck is the standard syntax? Is there a
> standard syntax? How about this syntax that I came up with:
>
> ALTER TABLE blah ALTER COLUMN col SET [NULL | NOT NULL]

If there is no standard syntax for this, I would recommend emulating oracle
or SQL server rather than coming up a new one. Why create yet another SQL
extension that is not compatible with anyone elses.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Swan 2002-02-16 04:36:06 Re: Change in casting behavior?
Previous Message Tatsuo Ishii 2002-02-16 03:44:12 7.2 and current timestamp bug?