]> 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>
Fri, 5 Jul 2019 14:18:10 +0000 (16:18 +0200)
commitcc052b423ad7dc92abb3461a096408c3997c36e1
tree0a8416ed8d9d07d0ce21ddefe1216e9b934781db
parent57f459cf6c48e78aa321ac88418815fc65197517
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