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

From Tom Lane
Subject Re: Show method of index
Date
Msg-id 2682.1242084609@sss.pgh.pa.us
Whole thread Raw
In response to Re: Show method of index  (Greg Stark <stark@enterprisedb.com>)
Responses Re: Show method of index  (Khee Chin <kheechin@gmail.com>)
List pgsql-hackers
Greg Stark <stark@enterprisedb.com> writes:
> On Tue, May 12, 2009 at 12:20 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 
>>         Index "public.fooi"
>>     Column      |  Type   | Definition
>> -----------------+---------+------------
>>  f1              | integer | f1
>>  pg_expression_2 | integer | (f2+f3)

> Is there any reason to expose "pg_expression_2" to the user at all?

Perhaps not, but if they did have a reason to access the individual
index column then they'd need to know its name.  I admit that there
may not be any such reason at present, but do you want to find us
having to change the definition back again sometime in the future?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5
Next
From: Josh Berkus
Date:
Subject: Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5