Re: Rationalizing EXPLAIN VERBOSE output

Thomas Lockhart wrote:
> > >> I'm not partial to the duplicated keyword. Really.
> > Okay, okay, I concede.  "EXPLAIN VERBOSE n stmt" it is.
> 
> Another possibility is to implement
> 
>   SET VERBOSITY = n;
> 
> Why not do that and not bother extending/polluting the EXPLAIN syntax?

Unless you have another use for VERBOSITY, it seems like a waste.   I
don't see a value in moving control away from the EXPLAIN command
itself.  I realize it would be used as a default for all EXPLAIN
commands, but the level is just a single-digit number.

--  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