Thread

  1. Re: Missing jsonb_ ... functions on DOCs

    Marcos Pegoraro <marcos@f10.com.br> — 2026-05-11T18:33:08Z

    Em seg., 11 de mai. de 2026 às 12:19, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
    
    > There are circa 800 entries in pg_operator (and that's just for the core
    > code).
    >
    
    It is precisely because of this number of operators that I would like to
    document the functions related to them.
    When you read SQL and there is an operator, you need to think, "Did I use
    the right operator? I'll check the documentation to see if that's the one."
    If I use a word, I have no doubt. The word Diff is completely different
    than the word Equal, but the operator != is very similar to the operator =
    
    Maybe we can find a way to have both on DOCs.
    Maybe put function name just after operator definition
    jsonb @> jsonb → boolean (jsonb_contains())
    Maybe a tooltip on that operator.
    
    I don't know how, but from a user's point of view, I know that not
    documenting isn't the best approach.
    
    regards
    Marcos