Martijn van Oosterhout wrote:
On Sun, Feb 19, 2006 at 10:34:02AM -0800, elein wrote:
Actually I can do and have done this. It is being tested now.
I did create an opclass. It creates a UNIQUE index just fine
for the type using the lower() functionality. *If* it passes
all of my testing I'll publish it tomorrow on general bits.
Perhaps folks can help try to break it when I publish (or
if you are around today Sunday, you can test in advance--email me
directly.)
How is this different from the citext module I suggested?
Have you looked at the code of citext? Unless I'm misreading, it creates
a lowercase copy of each string for each comparison. And it doesn't look
to me like it's encoding/locale aware.
No doubt it serves the author's needs, but I'd be very careful of using
or recommending it for general use.
I'm not sure how hard a text type with efficient, encoding and locale
aware, case-insensitive comparison would be to create , but it would be
a Good Thing (tm) to have available.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
