Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> I have a table with a TEXT field called "username". I'd like to retain the=
> =20
> case of the data stored here, but I'd like all comparisons to be done witho=
> ut
> regard to case. Since all these accesses _should_ be done through database=
> =20
> functions, I can simply lower() the input values and compare. I also have
> an index created on lower(username), so lookups are quick.
> However, I'd also like to have some sort of table constraint to make sure=
> =20
> alternate case "duplicate" records don't creep into the table. Any tips?
Make that index be UNIQUE.
BTW, please don't send HTML-coded mail to the lists. It's a pain in the
neck to quote.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: 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
