| From: | "tjk(at)tksoft(dot)com" <tjk(at)tksoft(dot)com> |
|---|---|
| To: | cedarc(at)visionforisrael(dot)com (Cedar Cox) |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Case insensitive string comparison? |
| Date: | 2001-05-21 11:53:45 |
| Message-ID: | 200105211153.EAA24780@smtp3.tksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
You can index the lower(...) queries, but you can't for the
regex queries.
Troy
>
>
> On Tue, 15 May 2001, Karel Zak wrote:
>
> > On Tue, May 15, 2001 at 02:48:24PM +0200, Borek Lupomìský wrote:
> > > Is there an operator for case insensitive string comparison, or
> > > should I use regular expression matching with ~* '^string$'?
> >
> > possibility:
> >
> > - use upper() / lower() inside query
>
> Ok, this is probably a really silly question: which is faster?
> I expect they are nearly identical code. Just wondering...
>
> -Cedar
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2001-05-21 12:48:23 | Re: HELP: what's wrong with my PL/PSQL function?? |
| Previous Message | Cedar Cox | 2001-05-21 09:15:41 | Re: Case insensitive string comparison? |