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

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 13 June 2006 14:42
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" <dpage@vale-housing.co.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.