Re: Patch to add support for partial indices

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Patch to add support for partial indices
Дата
Msg-id 20010716215030.C24087@svana.org
обсуждение исходный текст
Ответ на RE: Patch to add support for partial indices  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Patch to add support for partial indices  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Patch to add support for partial indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Mon, Jul 16, 2001 at 05:06:44PM +0800, Christopher Kings-Lynne wrote:
> > > 3. A needed feature not yet implemented is for psql's \d commands to
> > > show the predicate when displaying info about a partial index.
> >
> > I'll look at that. Can't be too difficult with the new get_expr
> > function :)
>
> If you're in there - might be useful if normal indices were shown with the
> keys they're defined over, rather than just the index name.

Well, I thought it'd be easy but a whole bunch of commands use the
listTables function which is great if they all output the same. However, to
add one column is not so easy. I mean, while I'm at it I could show the
query defining a view.

As for showing column names, I think you'd need a function to take a list of
names returned by a query and turn it into an array. Maybe there is such a
beast, but I havn't seen it yet.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.

В списке pgsql-patches по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Clear out the reminants of EXTEND INDEX
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Patch to add support for partial indices