Re: match an IP address - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: match an IP address
Date
Msg-id 48D80F7A.4000000@wildenhain.de
Whole thread Raw
In response to Re: match an IP address  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Responses Re: match an IP address  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
Hi,

Joao Ferreira gmail wrote:
> well...
>
> my IP addresses are stored in a TEXT type field. that field can actually
> contain usernames like 'joao' or 'scott' and it can contain IP
> addresses....

Any reason not to change this in the first place?

For a quick fix you could use regex to find the records
likely containing an ip-address notation.

Tino

Attachment

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: match an IP address
Next
From: "Phoenix Kiula"
Date:
Subject: Re: match an IP address