Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Roger Leigh <rleigh@xxxxxxxxxxxxx> 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

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux