pg_get_viewdef - opclass

Lists: pgsql-hackers
From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_get_viewdef - opclass
Date: 2006-06-12 11:12:11
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40138887F@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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.