Fix pg_mcv_list_items() to produce text[]

Tomas Vondra <tomas.vondra@postgresql.org>

Commit: cc052b423ad7dc92abb3461a096408c3997c36e1
Author: Tomas Vondra <tomas.vondra@postgresql.org>
Date: 2019-07-05T14:18:10Z
Releases: 12.0
Fix pg_mcv_list_items() to produce text[]

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

Files

Discussion