Re: Rationalizing EXPLAIN VERBOSE output

Thomas Lockhart wrote:
> ...
> > > >     EXPLAIN VERBOSE select * from pg_class;
> > > >     EXPLAIN LEVEL 1 select * from pg_class;
> > > >     EXPLAIN LEVEL 5 select * from pg_class;
> 
> How about leaving off "LEVEL" and just allow a numeric argument after
> VERBOSE? It does not give shift/reduce troubles. And I'm not sure that
> "level" makes it clearer (level of what?). So it would be
> 
>   EXPLAIN VERBOSE select ...
>   EXPLAIN VERBOSE 5 select ...

Yes, this was my initial proposal but Tom didn't like it.  Seemed very
clear to me.  Tom wants EXPLAIN VERBOSE VERBOSE.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026