Re: Convert int to hex

From: Richard Huxton <dev(at)archonet(dot)com>
To: Fernando Grijalba <fgrijalba(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Convert int to hex
Date: 2005-06-02 07:14:39
Message-ID: 429EB1DF.7060202@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Fernando Grijalba wrote:
> I want to be able to change an int4 from a sequence and store it as
> varchar in the database as a hex number.
>
> Is this possible?

Try the to_hex() function - in the "Functions and operators" chapter of
the manual - "Strings" section.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ramakrishnan Muralidharan 2005-06-02 09:17:40 Re: Convert int to hex
Previous Message Dinesh Pandey 2005-06-02 07:04:58 index row size 2728 exceeds btree maximum, 2713