Re: [GENERAL] dotted quad netmask conversion

2010-12-07 Thread Steve Clark
On 12/07/2010 11:43 AM, Tom Lane wrote: Steve Clark writes: Thanks for the response Jon. I should have stated this PG 8.1.x and '&' doesn't exist for network functions. I don't think& does what you want anyway. It just does a bit AND on the two addresses, it doesn't change the mask

Re: [GENERAL] dotted quad netmask conversion

2010-12-07 Thread Tom Lane
Steve Clark writes: > Thanks for the response Jon. I should have stated this PG 8.1.x and '&' > doesn't exist for network functions. I don't think & does what you want anyway. It just does a bit AND on the two addresses, it doesn't change the masklen property. There's probably only a small num

Re: [GENERAL] dotted quad netmask conversion

2010-12-07 Thread Steve Clark
On 12/07/2010 10:30 AM, Jon Nelson wrote: On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote: Hello All, I am working with a postgresql database that has two columns. One for an ip address and another for the netmask. Both of these columns are char varying(30). I would like to convert to ju

Re: [GENERAL] dotted quad netmask conversion

2010-12-07 Thread Jon Nelson
On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote: > Hello All, > > I am working with a postgresql database that has two columns. > One for an ip address and another for the netmask. Both of these > columns are char varying(30). I would like to convert to just > one column as inet. Any one know a

[GENERAL] dotted quad netmask conversion

2010-12-07 Thread Steve Clark
Hello All, I am working with a postgresql database that has two columns. One for an ip address and another for the netmask. Both of these columns are char varying(30). I would like to convert to just one column as inet. Any one know a slick way to convert the dotted quad netmask, E.G. 255.255.128