Re: Custom type, operators and operator class not sorting/indexing correctly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roger Leigh <rleigh(at)codelibre(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Custom type, operators and operator class not sorting/indexing correctly
Date: 2009-01-21 07:03:03
Message-ID: 24822.1232521383@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Roger Leigh <rleigh(at)codelibre(dot)net> writes:
> I've created a new domain (debversion) derived from TEXT, which
> includes its own operators (< <= = >= > and <>), and also its
> own operator class for BTREE indices.

You can't realistically attach such things to a domain; try making
a separate type, perhaps with an implicit cast to text to allow
use of text operators for other purposes.

Elein was going to look into tweaking the coercion rules so that
functions on domains had a non-negligible chance of being useful,
but we've not heard much about that project lately.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2009-01-21 07:47:22 autovacuum daemon
Previous Message Együd Csaba 2009-01-21 05:51:40 Re: Database schema & data synchronizer software for PostgreSQL?