Re: Indexing varchar fields with lower() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Indexing varchar fields with lower()
Date
Msg-id 7012.957544435@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexing varchar fields with lower()  ("Mitch Vincent" <mitch@huntsvilleal.com>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.0RC2 compile error !
Next
From: The Hermit Hacker
Date:
Subject: RFP: PostgreSQL Replication ...