IP Address Validation

Поиск
Список
Период
Сортировка
От Jasbinder Singh Bali
Тема IP Address Validation
Дата
Msg-id a47902760705092122s27acbe81h449ffac1676089ec@mail.gmail.com
обсуждение исходный текст
Ответы Re: IP Address Validation  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Brent Wood
Дата:
Сообщение: Re: Views- Advantages and Disadvantages
Следующее
От: David Wall
Дата:
Сообщение: Re: Replication for PG 8 recommendations