Re: [SQL] Join table with itself for heirarchial system?

2003-07-20 Thread Oleg Bartunov
You might look on our contrib/ltree module (http://www.sai.msu.su/~megera/postgres/gist/ltree) Oleg On Wed, 16 Jul 2003, Benjamin Smith wrote: > Can you query a set of nested entries to simulate a heirarchial system with a > single query? > > I'm building a nested category table with a de

Re: [SQL] inet versus text for ip addresses

2003-07-20 Thread Bruce Momjian
Dan Langille wrote: > The PostgreSQL inet datatype stores an holds an IP host address, and > optionally the identity of the subnet it is in, all in one field. > This requires 12 bytes. > > Using my "random" data of approximately 8000 IP addresses collected > during previous polls, I've foun