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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
