• Tomas Vondra's avatar
    Fix pg_mcv_list_items() to produce text[] · 4d66285a
    Tomas Vondra authored
    The function pg_mcv_list_items() returns values stored in MCV items. The
    items may contain columns with different data types, so the function was
    generating text array-like representation, but in an ad-hoc way without
    properly escaping various characters etc.
    
    Fixed by simply building a text[] array, which also makes it easier to
    use from queries etc.
    
    Requires changes to pg_proc entry, so bump catversion.
    
    Backpatch to 12, where multi-column MCV lists were introduced.
    
    Author: Tomas Vondra
    Reviewed-by: Dean Rasheed
    Discussion: https://postgr.es/m/20190618205920.qtlzcu73whfpfqne@development
    4d66285a
pg_proc.dat 538 KB