SET NULL / SET NOT NULL

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: SET NULL / SET NOT NULL
Date: 2002-02-13 02:46:46
Message-ID: GNELIHDDFBOCMGBFGEFOKEFOCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

This is the email I sent earlier - I think it was lost in the 7.2 release
hammering the servers got.

I'm hoping to implement SET NULL / SET NOT NULL for 7.3

I've been searching the SQL99 docs but I still can't figure out the syntax
for it. (BTW, can anyone give me SQL92?)

So I guess there are two possibilties - which is correct?:

ALTER TABLE blah ADD CONSTRAINT "asfd" NOT NULL (field);
ALTER TABLE blah DROP CONSRAINT "asdf";

or

ALTER TABLE blah ALTER COLUMN field SET [ NOT NULL | NULL ];

My question is - does the parser already support the syntax? ie. Is there
an empty function somewhere that says 'not implemented', or do I have to
actually add the flex code for it?

If it is there - where is it?

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-02-13 03:18:08 Re: Ready to branch 7.2/7.3 ?
Previous Message Lamar Owen 2002-02-13 01:21:14 Re: Mail archives problems