Re: RANGE type, and its subtype parameter

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: 'Guillaume Lelarge' <guillaume(at)lelarge(dot)info>, 'PostgreSQL-development' <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RANGE type, and its subtype parameter
Date: 2012-04-21 01:33:01
Message-ID: 001801cd1f5e$b11d3280$13579780$%kapila@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If I understood correctly the following query should give your answer:
Select opcintype from pg_opclass where opcname = '<operator class name>';
---Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Guillaume Lelarge
Sent: Friday, April 20, 2012 12:55 PM
To: PostgreSQL-development
Subject: [HACKERS] RANGE type, and its subtype parameter

Hi,

I'm working on adding support of range types in pgAdmin and I have a
really hard time understanding the subtype parameter of a range type.
How can I find all the types associated with a specific operator class?
I'm pretty sure it's a really dumb question, but I'm completely lost
here.

Thanks.

Regards.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-04-21 04:55:47 Re: Plan stability versus near-exact ties in cost estimates
Previous Message Fujii Masao 2012-04-20 19:58:59 Re: New sync commit mode remote_write