Re: Update Syntax

On 2010-04-29, at 20:20, Andy Seaborne wrote:

snip

>>> 2/ What happened to CLEAR DEFAULT etc?
>> 
>> I thought that "CLEAR" without anything else meant the same thing?
> 
> I recall a discussion about DEFAULT so that accidents like an uncompleted CLEAR didn't remove stuff by mistake.

Yup. It's less of an issue now we have explicit statement separators, but learning from SQL's DELETE FROM X problem is a good idea.

- Steve

-- 
Steve Harris, Garlik Limited
1-3 Halford Road, Richmond, TW10 6AW, UK
+44 20 8439 8203  http://www.garlik.com/
Registered in England and Wales 535 7233 VAT # 849 0517 11
Registered office: Thames House, Portsmouth Road, Esher, Surrey, KT10 9AD

Received on Thursday, 29 April 2010 21:19:46 UTC