Re: match an IP address
От | Joao Ferreira gmail |
---|---|
Тема | Re: match an IP address |
Дата | |
Msg-id | 1222165334.6786.82.camel@jmf-ubuntu обсуждение исходный текст |
Ответ на | Re: match an IP address (hubert depesz lubaczewski <depesz@depesz.com>) |
Список | pgsql-general |
thank you depesz it seems a pretty good fix for my problem. Actually yestreday I came up with something similar but your's is better. cheers joao On Tue, 2008-09-23 at 09:26 +0200, hubert depesz lubaczewski wrote: > On Mon, Sep 22, 2008 at 05:59:25PM +0100, Joao Ferreira gmail wrote: > > I'm unable to build a LIKE or SIMILAR TO expression for matching and ip > > address > > 192.168.90.3 > > 10.3.2.1 > > any help please... > > use this regular expression: > > '^[0-9]{1,3}(.[0-9]{1,3}){3}$' > > warning: do not use "like" or "similar to". > proper way to use it: > > select * from table where field ~ '^[0-9]{1,3}(.[0-9]{1,3}){3}$'; > > this regexp is not 100% fault proof - it will happily return rows like: > '300.999.998.7' > > but for most of the cases it should be enough. if you need it to match > only ips, and filter out things like '300.999.999.999' - let me know. > > Best regards, > > depesz >
В списке pgsql-general по дате отправления: