Updates with NULL
От
Shridhar Daithankar
Тема
Updates with NULL
Дата
Msg-id
3F661458.13553.39E18094@localhost
Список
Дерево обсуждения
Updates with NULL "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Updates with NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: Updates with NULL "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Updates with NULL Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Updates with NULL Manfred Koizar <mkoi-pg@aon.at>
Re: Updates with NULL Dennis Gearon <gearond@fireserve.net>
Hello All, I was just updating a table in oracle9.2 by hand and bumped into this. Following seems to be the valid syntax in oracle. Update foo set somefield=NULL where somefield >9; Now I am not sure having something equalled with NULL is a good thig logically. I would say Update foo set somefield [to] NULL where somefield >9; sounds much better. Postgresql uses =default expression which is fine. Is Oracle behaviour correct?
В списке pgsql-general по дате отправления
