Re: functional index "real world" uses

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: functional index "real world" uses
Дата
Msg-id 20040205200224.GA2671@dcc.uchile.cl
обсуждение исходный текст
Ответ на functional index "real world" uses  (David Garamond <lists@zara.6.isreserved.com>)
Список 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)

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Analyze not doing anything?
Следующее
От: "Oleg Lebedev"
Дата:
Сообщение: Re: dblink: rollback transaction