Re: Operator Comments

Mike Mascari wrote:
> Here's the history, FWIW:
> 
> I implemented COMMENT ON for just TABLES and COLUMNS, like Oracle.
> 
> Bruce requested it for all objects
> 
> I extended for all objects - including databases (my bad) ;-)
> 
> Peter E. was rewriting psql and wanted the COMMENT on operators to
> reflect a COMMENT on the underlying function
> 
> I submitted a patch to do that - I just do what I'm told ;-)

Actually, the use of function comments for operators goes back to when I
added comments to system tables in include/catalog.  I wanted to avoid
duplication of comments so I placed them only on the functions and let
the operators display the function comments.  Were there cases where we
don't want the function comments for certain operators?  I never
anticipated that.

Anyway, I looked at the new psql code and it works fine, tries
pg_operator description first, then pg_proc if missing.

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