From: nolan@celery.tssi.com
To: pgman@candle.pha.pa.us
Cc: pgsql-general@postgresql.org
Subject: MySQL/PG search times
Date: Mon, 23 Jun 2003 13:11:19 -0500 (CDT)
Message-ID: <20030623181119.942.qmail@celery.tssi.com> (raw)
In-Reply-To: <200306231641.h5NGftj12393@candle.pha.pa.us>
> We require ~* syntax for that, or upper()/lower().
Slowly the light dawns!
If I anchor a ~ search on both ends, it is the same search as =.
Duh!
I converted the prototype over to use ~ and it is running much faster.
I'll try to do some detailed timings against MySQL tonight.
--
Mike Nolan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: nolan@celery.tssi.com, pgman@candle.pha.pa.us, pgsql-general@postgresql.org
Subject: Re: MySQL/PG search times
In-Reply-To: <20030623181119.942.qmail@celery.tssi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox