Re: [GENERAL] Need help with Inet type

2013-09-12 Thread rob stone
On Wed, 2013-09-11 at 21:49 -0700, arohi wrote: > Hi All, > > I am trying to install postgresql-jdbc but facing java error. sun java is > already installed but postgresql-jdbc installing openjdj. please let me know > how to resolve this and if you require any other details. > > > > - > AR

Re: [GENERAL] Need help with Inet type

2013-09-12 Thread arohi
Hi All, I am trying to install postgresql-jdbc but facing java error. sun java is already installed but postgresql-jdbc installing openjdj. please let me know how to resolve this and if you require any other details. - AROHI -- View this message in context: http://postgresql.1045698.n5.nab

Re: [GENERAL] Need help with Inet type

2013-09-10 Thread Christoph Moench-Tegeder
## Eric Lamer (eric.la...@intact.net): > I can do something like: > >Select * From logs Where src_ip IN (Select ip from ip_table where zone > = 'ZONE_a'); > >Of course that does not work since it does not work with Inet type and > I cannot use << because I have more than 1 row return

[GENERAL] Need help with Inet type

2013-09-10 Thread Eric Lamer
Hi, I would like to know if there is a way to do what I need with Postgress. I have a table with logs and a table with a list of subnets. Right now I do the following query in my table: Select * From logs Where src_ip << '10.0.0.0/24' OR src_ip << '10.1.0.0/24' OR src_ip << '172.1