Re: SQL Implementation

On Mon, 06 Oct 2003 05:39:32 +0000, Jonathan Leffler wrote:

> One useful feature: savepoints and explicit transaction boundaries.
> One dubious feature: table inheritance

While they may not be very widely implemented yet, I think that the following new features are at least potentially nice:

• triggers
• BOOLEAN and BLOB data types
• more cases where views may be updateable
• more built-in functions like ABS() end such
• user defined types

I doubt that _core_ SQL-1999 is _much_ larger/more bloated than SQL-92. According to section C.2 of [1], SQL-1999 actually cleans up some stuff from SQL-92.

Reference 1:
http://www.bhusa.com/computing/us/subindex.asp?maintarget=/bookscat/search/details.asp&isbn=1558604561

-- 
Greetings from Troels Arvin, Copenhagen, Denmark