Re: Case Insensitive Data Type

Darren Ferguson <darren@crystalballinc.com> writes:
> Could / Would it be very difficult to add ON SELECT triggers to Postgres?

Don't see that it would help you.  An ON SELECT trigger would presumably
fire when a row is selected --- but you are trying to alter the
selection conditions, and cause rows to be selected that would *not* be
normally.  There is no place for a trigger to fire to make that happen.

Note that it'd be easy enough for a rule to add lower() to the reference
to email --- really all you're doing there is making a view that
replaces the email column with a lowercased version of it.  But I don't
see a way for a rule to rewrite the query to lower-case the literal
constant being compared to email.  Can anyone see a way to do it?

            regards, tom lane