| 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: | Whole Thread | Raw Message | 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 |