Re: SET NULL / SET NOT NULL - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: SET NULL / SET NOT NULL
Date
Msg-id m3r8nfd1bq.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: SET NULL / SET NOT NULL  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: SET NULL / SET NOT NULL  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:

> I'm not too fond of 'SET NULL' - the syntax implies the column is being set
> to NULL. But I agree with the rest given we already have ALTER
> TABLE...ALTER COLUMN, I'd vote for:
> 
>     ALTER TABLE blah ALTER COLUMN col [ALLOW NULL | NOT NULL]

FWIW, I like this syntax too.

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.  --T. J. Jackson, 1863


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: SET NULL / SET NOT NULL
Next
From: Thomas Lockhart
Date:
Subject: Re: date/time compatible problems in 7.2