[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs
From:       Luca Ferrari <fluca1978 () infinito ! it>
Date:       2017-11-20 8:05:03
Message-ID: CAKoxK+6BN7BSVKg-aZdFmEMutP+QbyuwN4pftS89ohB-zHTyRw () mail ! gmail ! com
[Download RAW message or body]

On Fri, Nov 17, 2017 at 9:41 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:
> I think you want something like this ?
> 
> postgres=# SELECT schemaname, tablename, attname, \
> unnest(histogram_bounds::text::text[]), histogram_bounds FROM pg_stats LIMIT 9; \
> pg_catalog | pg_pltemplate | tmplname    | plperl              | \
> {plperl,plperlu,plpgsql,plpython2u,plpython3u,plpythonu,pltcl,pltclu}

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?

Luca


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[prev in list] [next in list] [prev in thread] [next in thread]