Thread: 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

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@postgresql.org [mailto:pgsql-hackers-owner@postgresql.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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On Sat, 2012-04-21 at 07:03 +0530, Amit Kapila wrote:
> If I understood correctly the following query should give your answer:
> Select opcintype from pg_opclass where opcname = '<operator class name>';

You're right, and my question was wrong. I finally found the SQL query I
was looking for.

Thanks.


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