Re: int to inet conversion [or Re: inet to bigint?]

Поиск
Список
Период
Сортировка
От Volkan YAZICI
Тема Re: int to inet conversion [or Re: inet to bigint?]
Дата
Msg-id 20051210092752.GD586@alamut
обсуждение исходный текст
Ответ на Re: int to inet conversion [or Re: inet to bigint?]  (Kai <kai@xs4all.net>)
Ответы Re: int to inet conversion [or Re: inet to bigint?]
Список pgsql-hackers
On Dec 08 04:36, Kai wrote:
> After working regularly with inet values in sql, it would be nice to be able
> to do this:
> 
>     => select '192.168.1.1'::inet + 1 as result;
>        result    
>     -------------
>      192.168.1.2
>     (1 row)

You may take a look at ip4r[1] project too. For a full list for its
availabilities (like +/- operators) here[2] is the related SQL file.

[1] http://pgfoundry.org/projects/ip4r/
[2] http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/ip4r/ip4r/ip4r.sql.in?rev=1.4&content-type=text/plain


Regards.

-- 
"We are the middle children of history, raised by television to believe
that someday we'll be millionaires and movie stars and rock stars, but
we won't. And we're just learning this fact," Tyler said. "So don't
fuck with us."


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

Предыдущее
От: Guillaume LELARGE
Дата:
Сообщение: Something I don't understand with the use of schemas
Следующее
От: Markus Schiltknecht
Дата:
Сообщение: Re: Replication on the backend