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(at)storagetek(dot)com Fax: (763) 391-1095
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org