Re: hex values

Hi,

as far as I've found out, it doesn't.
Retrieving int data as hex I solved by this  plperl function:

CREATE FUNCTION int2hex(integer) RETURNS char(10)
    AS '$tmp = sprintf "%X", $_[0];
        return ("0x" . "0"x(4-length($tmp)) . $tmp);'
    LANGUAGE 'plperl';

This will give you allways 4 ciphers behind 0x. I didn't need it for
reading data, but at least, it should work about the same, i.e. if you have
several kinds of numbers, some dec, some hex, some oct, I would do
something like:

CREATE FUNCITON mynumber2int(char(10)) RETURNS integer
    AS 'return int($_[0]);'
    LANGUAGE 'plperl';

which simply uses perls internal conversion-mechanism.


I would also like postgres to include this behavior by default, at least
for the reading. But I haven't found out how.


Heiko

Oberpriller, Wade D. writes:
 > Does Postgres support hex values?
 >
 > Can I do something like:
 >
 > VAL := 0xFFFF;
 >
 > And is it possible to output the value in a hex-string? So VAL would display
 > as 0xFFFF instead of 65535?
 >
 > Wade Oberpriller                 http://www.storagetek.com
 > Software Development             Phone: (763) 424-1538
 > StorageTek: MRDC                        (800) 328-9108 ext. 1538
 > wade_oberpriller@storagetek.com  Fax:   (763) 391-1095
 >
 > ---------------------------(end of broadcast)---------------------------
 > TIP 6: Have you searched our list archives?
 >
 > http://archives.postgresql.org