Re: pg_get_INDEXdef - opclass

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 13 June 2006 14:42
> To: Dave Page
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
> > Right, but how can I conditionally join with pg_opclass
> based on whether
> > or not the opclass specified for the column is the default for that
> > type?
>
> Check pg_opclass.opcdefault and compare pg_opclass.opcintype to the
> index column's datatype (which you'd get from its pg_attribute row
> ... whether it's an expression is irrelevant).

Ahh right - thanks. I got it into my head that there was no pg_attribute
row for an expression. Must be the sun...

Regards, Dave.