Re: Index not used in functions in 7.0? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Index not used in functions in 7.0?
Date
Msg-id Pine.LNX.4.21.0005162246470.362-100000@localhost.localdomain
Whole thread Raw
In response to Re: Index not used in functions in 7.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane writes:

> select attname,attdisbursion,s.*
> from pg_statistic s, pg_attribute a, pg_class c
> where starelid = c.oid and attrelid = c.oid and staattnum = attnum
> and relname = 'FOO';
> 
> (I'm beginning to think we should create a standard system view
> for this query ;-))

\dstats?


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Storing binary data in a column
Next
From: Brook Milligan
Date:
Subject: Re: question on update/delete rules on views