SET NULL / SET NOT NULL

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема SET NULL / SET NOT NULL
Дата
Msg-id GNELIHDDFBOCMGBFGEFOKEFOCBAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: SET NULL / SET NOT NULL  (Peter Eisentraut <peter_e@gmx.net>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Rishabh Gupta"
Дата:
Сообщение: data mining or statistical analysis with postgresql
Следующее
От: "Mark Pritchard"
Дата:
Сообщение: Re: Connection Pooling