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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org