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