2007/11/19, Tom Allison <tom@xxxxxxxxxxx>: > I am planning on doing a LOT of work with ip addresses and thought that the > inet data type would be a great place to start. > > But I'm not sure how this works in with accessing the addresses. In perl or > ruby how is the value returned? In Perl the value is returned as a scalar. > Or should I stricly use host() and other functions to be explicit about what > I'm doing. > > > Another question. > Given a subnet (eg: 192.168.1.0/24) is there some way to pull all the > addresses therein? > I can do this in code - but I was curious if there was a postgres way of > doing it (didn't see any, but..) You want the network address functions and operators, I presume: http://www.postgresql.org/docs/8.2/interactive/functions-net.html HTH Ian Barwick -- http://sql-info.de/index.html ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
