CREATE TYPE for case insensitive text and varchar

From: Daniel Migowski <nur-gueltig-bis-2003-12-01(at)Mig-O(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE TYPE for case insensitive text and varchar
Date: 2003-10-30 08:42:47
Message-ID: bnqiuf$2u9v$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hallo.

i just coded a new datatype named "cistring", that can be
used in every function that accepts text or varchar, and has
the great ability to be ordered case insensitive in ORDER BY-
Clauses and Indices. The problem is, that its coded like the
text-type, so it is variable length completly.

I miss the possibility to code something like a userdifined
varchar(n). I don't know how to create an input function,
that accepts the size of the type, or a function, how to declare
such types at all. I think, somethink like a userdefined
numeric(n,m) isn't possible, too, or am I wrong?

Thank you for all replies,
Daniel Migowski

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michele Bendazzoli 2003-10-30 12:35:34 Bug in Rule+Foreing key constrain?
Previous Message Tom Lane 2003-10-30 03:58:30 Re: Fwd: Re: Call for port reports