CREATE TYPE for case insensitive text and varchar - Mailing list pgsql-hackers

From Daniel Migowski
Subject CREATE TYPE for case insensitive text and varchar
Date
Msg-id bnqiuf$2u9v$1@news.hub.org
Whole thread Raw
Responses Re: CREATE TYPE for case insensitive text and varchar
List 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



pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: PQunescapeBytea code
Next
From: Vatsal Avasthi
Date:
Subject: Deadlock problem