> -----Original Message-----
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 13 June 2006 14:42
> To: Dave Page
> Cc: [email protected]
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" <[email protected]> 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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
