Re: Question about pattern matching

From: dimitris(dot)sakellarios(at)telesuite(dot)gr
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about pattern matching
Date: 2008-12-23 18:12:19
Message-ID: 20081223201219.qhzyenhdq8owwsc0@zeus.netdynamics.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thanks alot for your help.

Dimitris

Quoting Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:

> SELECT ... from ..... WHERE X LIKE pattern || '%' ORDER BY
> length(pattern) DESC LIMIT 1;
>
> ???
>
> basic prefix matching for telcos :P
>
> --
> GJ
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2008-12-23 19:17:33 Re: Question about pattern matching
Previous Message dimitris.sakellarios 2008-12-23 18:11:24 Re: Question about pattern matching