Request a Demo
Home   >   mailing lists

Re: Convert int to hex - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Convert int to hex
Date
Msg-id 429EB1DF.7060202@archonet.com
Whole thread Raw
In response to Convert int to hex  (Fernando Grijalba <fgrijalba@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: index row size 2728 exceeds btree maximum, 2713
Next
From: "Dinesh Pandey"
Date:
Subject: Re: index row size 2728 exceeds btree maximum, 2713