[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

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 exception