[HACKERS] Debugging tool for viewing parse trees?

2003-06-08 Thread Eric D Nielsen
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 broadcast)-

Re: [HACKERS] Updateable views...

2003-03-07 Thread Eric D Nielsen
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 QS is

Re: [HACKERS] Updateable views...

2003-03-07 Thread Eric D Nielsen
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 bro

Re: [HACKERS] Updateable views...

2003-03-05 Thread Eric D Nielsen
> 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'

Re: [HACKERS] Updateable views...

2003-03-05 Thread Eric D Nielsen
> 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)

[HACKERS] Updateable views...

2003-03-04 Thread Eric D Nielsen
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. Recen