Re: [GENERAL] IP Address Validation

2007-05-09 Thread Michael Fuhr
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 exce

[GENERAL] IP Address Validation

2007-05-09 Thread Jasbinder Singh Bali
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