Howdy, Alvaro, Fernando and Harald.
Thanks a lot for your prompt reply.
As I'm in a big hurry with this I used the regular expressions thing, it
worked fine.
But your solution looks good as well, Alvaro, the problem is my poor
knowledge on pgplsql
Definitely, I have to study in more depth subjects like pgplsql not to
mention regular expressions
Thanx a lot for your fast help,
Best,
Oliveiros
----- Original Message -----
From: "Alvaro Herrera" <alvhe...@commandprompt.com>
To: "Oliveiros C," <oliveiros.crist...@marktest.pt>
Cc: <pgsql-sql@postgresql.org>
Sent: Friday, December 11, 2009 4:28 PM
Subject: Re: [SQL] 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
