| Lists: | pgsql-hackers |
|---|
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RANGE type, and its subtype parameter |
| Date: | 2012-04-20 07:25:26 |
| Message-ID: | 1334906726.4142.6.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| 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 |
| 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
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
| Cc: | 'PostgreSQL-development' <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: RANGE type, and its subtype parameter |
| Date: | 2012-04-21 15:52:05 |
| Message-ID: | 1335023525.19769.2.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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