Re: Indexing varchar fields with lower()

"Mitch Vincent" <mitch@huntsvilleal.com> writes:
> Could putting that function in there even though it's not 'built-in' cause
> any problems that you can think of? (Mainly worried about any kind of index
> corruption like I've seen before)

No, shouldn't be a problem.  The only thing non "built in" about it is
that fmgr.c has to find the function by name rather than by OID (there's
a shortcut for the OIDs of the standard pg_proc entries).  So the lookup
is a tad slower, that's all.

			regards, tom lane