Home > mailing lists

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

From	Grzegorz Jaśkiewicz
Subject	Re: Question about pattern matching
Date	December 23, 2008 17:06:57
Msg-id	2f4958ff0812231006s2961d732wb52ac0bbb5a67f40@mail.gmail.com Whole thread Raw
In response to	Question about pattern matching (dimitris.sakellarios@telesuite.gr)
Responses	Re: Question about pattern matching
List	pgsql-general

SELECT ... from ..... WHERE X LIKE pattern || '%' ORDER BY
length(pattern) DESC LIMIT 1;

???

basic prefix matching for telcos :P

--
GJ

From: Julius Tuskenis
Date: 23 December 2008, 16:31:31
Subject: Re: Question about pattern matching

From: dimitris.sakellarios@telesuite.gr
Date: 23 December 2008, 17:11:48
Subject: Re: Question about pattern matching