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