pg_get_viewdef - opclass

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
Thread:
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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-06-12 11:13:45 Re: pg_get_INDEXdef - opclass
Previous Message Aaron Bingham 2006-06-12 09:46:46 Re: Fabian Pascal and RDBMS deficiencies in fully implementing