I've gotten back to working on the SQL99 version of updateable views and
I'ld like to confirm my current understanding of the parse tree data
structure. Is there a debugging-type tool for outputting the parse tree for
a given query?
Eric Nielsen
---(end of
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?
Eric Nielsen
---(end of
After finding the SQL92 draft spec that Tom quoted from earlier I think I
understand the conditions for the spec's version of view updatability. I've
made few comments below on the conditions and I'ld appreciate it if anyone
would correct any mis-interpretations on my part.
12)A query
On Tue, 2003-03-04 at 15:26, Eric D Nielsen wrote:
The one place I haven't been able to use PostGreSQL to experiment is with
regards to updateable views. I've found a few threads in -general and -hac
kers
(including one linked from the ToDo list), but they all seem to die out wit
hout
Gavin Sherry [EMAIL PROTECTED] writes:
I haven't had time to look into it further, but it occurs to me that
handling views which rely on joins would be far from trivial.
Views containing joins would not be updatable; problem solved.
I see how that is what the spec says, but aren't the
Let me preface this by expressing my appreciation for all the hard work
for the people who develop, maintain, and support PostGreSQL. I've been
using it for a little over two years for a variety of projects and have
been extremely happy with both the software and the support on these lists.
