to_hex leading zeroes

From: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
To: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: to_hex leading zeroes
Date: 2009-03-15 12:47:00
Message-ID: 200903151247.15640.pdoria@netmadeira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-03-15 14:11:15 Re: to_hex leading zeroes
Previous Message ataherster 2009-03-15 06:17:01 [ask] Return Query