RANGE type, and its subtype parameter

Started by Guillaume Lelargealmost 14 years ago3 messageshackers
Jump to latest
#1Guillaume Lelarge
guillaume@lelarge.info

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

#2Amit Kapila
amit.kapila16@gmail.com
In reply to: Guillaume Lelarge (#1)
Re: RANGE type, and its subtype parameter

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

#3Guillaume Lelarge
guillaume@lelarge.info
In reply to: Amit Kapila (#2)
Re: RANGE type, and its subtype parameter

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