pg_get_viewdef - opclass - Mailing list pgsql-hackers

From Dave Page
Subject pg_get_viewdef - opclass
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40138887F@ratbert.vale-housing.co.uk
Whole thread Raw
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: TODO: Add pg_get_acldef(), pg_get_typedefault(),
Next
From: "Dave Page"
Date:
Subject: Re: pg_get_INDEXdef - opclass