Обсуждение: pg_get_viewdef - opclass

Поиск
Список
Период
Сортировка

pg_get_viewdef - opclass

От
"Dave Page"
Дата:
Following a pgAdmin bug report, I noticed that pg_get_viewdef doesn't
return the opclass when called for a specific column (in 8.1 at least) -
for example, for the index:

CREATE UNIQUE INDEX bar_pattern_idx2 ON foofoo USING btree
(lower((bar)::text) bpchar_pattern_ops, bar2)

A query on column 1 returns:

lower((bar)::text)

It seems to me that the opclass should be included as well.

Regards, Dave.