Re: Show method of index - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Show method of index
Date
Msg-id 200907062002.48000.peter_e@gmx.net
Whole thread Raw
In response to Re: Show method of index  (Khee Chin <kheechin@gmail.com>)
List pgsql-hackers
On Tuesday 12 May 2009 08:36:20 Khee Chin wrote:
> postgres=# \di idx_foo_bt_fooi;
>                                      List of relations
>  Schema |      Name       | Type  | Owner | Table | Method |         
> Definition
> --------+-----------------+-------+-------+-------+--------+---------------
>---------------- public | idx_foo_bt_fooi | index | rubik | foo   | btree  |
> md5((a)::text), md5((a || b))
> (1 row)
>
> postgres=# \d idx_foo_bt_fooi;
>     Index "public.idx_foo_bt_fooi"
>      Column      | Type |  Definition
> -----------------+------+--------------
>  pg_expression_1 | text | md5(a::text)
>  pg_expression_2 | text | md5(a || b)
> btree, for table "public.foo"

I have committed the second part, the additions to the \d output.  I think the 
sentiment was against changing the \di output.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )
Next
From: Jeff Davis
Date:
Subject: Re: WIP: generalized index constraints