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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend