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
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 |