Re: [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs - Mailing list pgsql-general

Luca Ferrari <fluca1978@infinito.it> writes:
> I don't think it is what I'm looking for, I would like something ,like:
>  select unnest( histogram_bounds::text::text[] ), unnest(
> most_common_freqs ) from pg_stats
> but with correlation between the two array indexes. Is it something
> achievable in SQL? Or should I use a plpgsql loop with an index?

Those two aren't correlated ... but I think what you want is

select ...,v,f
from pg_stats, rows from (unnest(most_common_vals::text::text[]),            unnest(most_common_freqs)) r(v,f)
where ...

Seems to work back to 9.4.
        regards, tom lane