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