Re: Updateable views...

Eric D Nielsen <nielsene(at)MIT(dot)EDU> writes:
> I'm pressing ahead with trying to implement the SQL92 version of updateable
> views. I'm trying to track down a copy of the SQL92 standard, I thought that
> ANSI sold them, but I can only find SQL89 and SQL99 there; am I looking in
> the wrong place?

I'm not sure that ANSI would bother with obsoleted versions of
standards. What I tend to use is the final draft version of SQL92,
mainly because it's available in plain text that I can grep (PDF is not
a user-friendly format IMHO). The draft version is available for free
on the net --- I've forgotten exactly where, but if you trawl the list
archives you will find a URL. SQL99 is available in the same way, btw.
But I like SQL92 because it's much smaller and more readable.

regards, tom lane