Re: self defined data type "with limit"?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Michael Enke <michael(dot)enke(at)wincor-nixdorf(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: self defined data type "with limit"?
Date: 2007-06-27 17:42:05
Message-ID: 4682A16D.6040800@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Enke wrote:
> My primary goal is to get quasi numeric ordering on text column, e.g.
> 1
> 2
> 10
> Normal order with varchar would be
> 1
> 10
> 2

You don't need to custom type for that. A custom operator class with
custom comparison operators is enough.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-06-27 18:00:36 Re: GiST consistent function, expected arguments; multi-dimensional indexes
Previous Message Michael Enke 2007-06-27 17:11:16 Re: self defined data type "with limit"?