Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about pattern matching - Mailing list pgsql-general

From dimitris.sakellarios@telesuite.gr
Subject Re: Question about pattern matching
Date
Msg-id 20081223201219.qhzyenhdq8owwsc0@zeus.netdynamics.gr
Whole thread Raw
In response to Re: Question about pattern matching  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
thanks alot for your help.

Dimitris

Quoting Grzegorz Jaśkiewicz <gryzman@gmail.com>:

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

pgsql-general by date:

Previous
From: dimitris.sakellarios@telesuite.gr
Date:
Subject: Re: Question about pattern matching
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Question about pattern matching