On Jul 14, 2005, at 3:14 AM, Rob Brenart wrote:
I have a simple table to store account names... I want each name to
be unique in a case insensitive manner... but I want the case the
user enters to be remembered so I can't do a simple lower() on the
data's way in.
Is there an easy way to go about this? Am I about to write my first
server side function for postgresql?
create your unique index using the lower() function.
and don't steal threads to start a new one (ie, replying then just
changing the subject)
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
