]> granicus.if.org Git - postgresql/commit
Fix pg_mcv_list_items() to produce text[]
authorTomas Vondra <tomas.vondra@postgresql.org>
Thu, 4 Jul 2019 21:43:04 +0000 (23:43 +0200)
committerTomas Vondra <tomas.vondra@postgresql.org>
Thu, 4 Jul 2019 23:32:46 +0000 (01:32 +0200)
commit4d66285adc6bb4f9e4fd394d478d663cbccb5fc8
tree9afc5c0ef3f77893c61ac60acf63f421bb0c716c
parente365a581c246a8e18f38cc530013391329dcdb02
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
src/backend/statistics/mcv.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/stats_ext.out