On 7/16/07, Steve Atkins [EMAIL PROTECTED] wrote:
On Jul 16, 2007, at 11:36 AM, Michael Nolan wrote:
I have data (from an external source) which is in text format as a
hex number (it's actually an IP address, but that's probably not
relevant.)
It likely is relevant, as it means it's a 32
I have data (from an external source) which is in text format as a hex
number (it's actually an IP address, but that's probably not relevant.)
to_hex gets from integer to hex, I can cast a hex constant to integer (ie
x'12a7'31'::int, but how do I get a database column from string/hex to
integer?
On Jul 16, 2007, at 11:36 AM, Michael Nolan wrote:
I have data (from an external source) which is in text format as a
hex number (it's actually an IP address, but that's probably not
relevant.)
It likely is relevant, as it means it's a 32 bit unsigned integer,
which isn't something