Re: [HACKERS] CREATE TYPE for case insensitive text and varchar

2003-10-30 Thread Jan Wieck
Tom Lane wrote: Daniel Migowski <[EMAIL PROTECTED]> writes: I miss the possibility to code something like a userdifined varchar(n). You're out of luck on that. The data types that can have precision parameters attached to them are hard-wired into the parser. Maybe you don't need to invent a whole

Re: [HACKERS] CREATE TYPE for case insensitive text and varchar

2003-10-30 Thread Tom Lane
Daniel Migowski <[EMAIL PROTECTED]> writes: > I miss the possibility to code something like a userdifined > varchar(n). You're out of luck on that. The data types that can have precision parameters attached to them are hard-wired into the parser. regards, tom lane --

[HACKERS] CREATE TYPE for case insensitive text and varchar

2003-10-30 Thread Daniel Migowski
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.