On Saturday, July 7, 2012 5:25:31 PM UTC-6, cult hero wrote: > > I've been looking for the best way to deal with that amounts to a case > insensitive column in PostgreSQL. (It stores email addresses.) I've found a > couple of options (an index using lower() and triggers using lower()) but > is there some way to make validates_unique do so in an insensitive manner? > That way is [email protected] is entered, [email protected] will still > anger the validation gods. Or do I need to make my own validation for this?
Use citext to store the email address. http://www.postgresql.org/docs/9.1/static/citext.html -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/tNYmC_yC-zgJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
