Thread: IP Address Validation

Hi,
I need to check whether the input string is in ip address format or not in one of my pl/pgsql functions.
What function should be used to accomplish this

I tried using
if inet(strInput)

However, it throws an exception if the input string is not in IP address format.

I could have caught this exception but really don't know what type of exception category would this exception come under..

Any kind of help would be highly appreciated.

Thanks,

Jas

On Thu, May 10, 2007 at 12:22:37AM -0400, Jasbinder Singh Bali wrote:
> I need to check whether the input string is in ip address format or not in
> one of my pl/pgsql functions.
> What function should be used to accomplish this
>
> I tried using
> if inet(strInput)
>
> However, it throws an exception if the input string is not in IP address
> format.
>
> I could have caught this exception but really don't know what type of
> exception category would this exception come under..

psql test
test=> \set VERBOSITY verbose
test=> select inet('junk');
ERROR:  22P02: invalid input syntax for type inet: "junk"

http://www.postgresql.org/docs/8.2/interactive/errcodes-appendix.html

22P02    INVALID TEXT REPRESENTATION    invalid_text_representation

--
Michael Fuhr