Re: match an IP address

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: match an IP address
Date: 2008-09-22 21:34:50
Message-ID: 48D80F7A.4000000@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2008-09-23 00:06:16 Re: match an IP address
Previous Message Scott Marlowe 2008-09-22 17:21:48 Re: match an IP address