| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: functional index "real world" uses |
| Date: | 2004-02-05 20:02:24 |
| Message-ID: | 20040205200224.GA2671@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 06, 2004 at 12:29:07AM +0700, David Garamond wrote:
> * creating a REVERSE_DOT(field) function for IP addresses and hostnames
> to allow wildcard searches (*.yahoo.com) using 'REVERSE_DOT(f) LIKE
> 'com.yahoo.%'.
I know a local telco company (hum, is this RAS syndrome?) uses this,
reversing phone numbers, so they allow search by prefix and suffix.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Right now the sectors on the hard disk run clockwise, but I heard a rumor that
you can squeeze 0.2% more throughput by running them counterclockwise.
It's worth the effort. Recommended." (Gerry Pourwelle)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-02-05 20:04:00 | Re: Proper tool to display graphics? |
| Previous Message | Peter Eisentraut | 2004-02-05 20:00:01 | Re: Can LIKE use indexes or not? |