> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 13 June 2006 14:42
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" writes:
> > Right, but how
"Dave Page" 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_att
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2006 18:32
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" writes:
> >> Fol
"Dave Page" writes:
>> 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) -
> Bah, I mean pg_get_indexdef of course :-)
This is intentional --- whoever asked for the per-column variant of
the indexd
Bah, I mean pg_get_indexdef of course :-)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 12 June 2006 12:12
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] pg_get_viewdef - opclass
>
> Following a pgAdmin bug report, I n
