[GENERAL] to_hex leading zeroes

2009-03-15 Thread Pedro Doria Meunier 
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



signature.asc
Description: This is a digitally signed message part.

Re: [GENERAL] to_hex leading zeroes

2009-03-15 Thread Scott Marlowe 
On Sun, Mar 15, 2009 at 6:47 AM, Pedro Doria Meunier
pdo...@netmadeira.com wrote:
 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' .

Have you looked at lpad()?

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general