Postgres Pro
Downloads
Home   >   mailing lists

to_hex leading zeroes - Mailing list pgsql-general

From Pedro Doria Meunier
Subject to_hex leading zeroes
Date
Msg-id 200903151247.15640.pdoria@netmadeira.com
Whole thread Raw
Responses Re: to_hex leading zeroes  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
Hi All,

I'm in a bit of a pickle here with the to_hex function not returning leading
zeroes ...
For instance if I:
SELECT to_hex(10);

it returns 'a' not '0a' .

Any ideas on how to overcome this?

TIA,

Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
Attachment

pgsql-general by date:

Previous
From: ataherster
Date:
Subject: [ask] Return Query
Next
From: Scott Marlowe
Date:
Subject: Re: to_hex leading zeroes