Re: Is there any function to test for numeric ips?

Oliveiros C, wrote:

> I've realized that, for ex, inet 'x.x.x.x' will fail if the input is not a numeric IP, 
> is there any simple and direct way to somewhat trap that error and convert it to a false value that can be used
> in a WHERE clause?

Yes, you can create a plpgsql function with an exception block; return
false inside the exception, true otherwise.  It looks something like

begin perform $1::inet; return true;
exception when invalid_something then   return false
end;

I don't remember the exact syntax and the exception name but that should
get you started.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support