From: | vessey(at)upei(dot)ca |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Extracting octets from an inet column |
Date: | 2001-07-15 14:39:20 |
Message-ID: | 3B5180E8.4413.1180A60@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm trying to find a method I can use to extract octets from an inet
value. I have a column that contains host addresses, which are all
currently stored as "/32." I'd like to be able to extract the third and
fourth octets of the address individually (due to the way we assign
IP addresses on our campus, this would be a useful thing to do).
This could be complete brain freeze, but I can't find a way to do it.
I've looked at trying to change the mask length from "/32" to "/24",
which would then let me get at the last octet using the host()
function. I saw a reference to a set_masklen() function in 7.2, but
I'm using 7.1.2. I looked at trying to convert a value to text,
manipulate the text, and then convert it back to an inet, but can't
find a magic combination to do this.
I also failed to find a way to access the raw byte values as
something like bit strings, which I could then play with.
Can anyone point me in the right direction?
Thanks!
Blair
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Blair Vessey VESSEY(at)UPEI(dot)CA
Systems Manager, University of Prince Edward Island
Charlottetown, Prince Edward Island, Canada C1A 4P3
=-= Voice: (902) 566-0388 Fax: (902) 566-0958 =-=
"An ounce of perception, a pound of obscure" - Rush
From | Date | Subject | |
---|---|---|---|
Next Message | Jason DiCioccio | 2001-07-15 19:07:18 | PASSWORD() function for postgresql? |
Previous Message | Bruce Momjian | 2001-07-15 14:35:18 | Re: [PATCH] To remove EXTEND INDEX |