Re: hexadecimal values - Mailing list pgsql-general

From Jeff Davis
Subject Re: hexadecimal values
Date
Msg-id 200205021744.KAA16811@smtp.ucsd.edu
Whole thread Raw
In response to hexadecimal values  (Thierry Besancon <Thierry.Besancon@paris4.sorbonne.fr>)
List pgsql-general
What do you mean you won't know in advance? If not, how do you tell the
difference between 10 hexadecimal (which is 16) and 10 decimal (which is 10)?

Have you considered just having your application convert it first? There may
be a postgresql function to convert it as well, however I couldn't find it
offhand. You could also create your own stored procedure.

Regards,
    Jeff

On Thursday 02 May 2002 04:28 am, Thierry Besancon wrote:
>         Hello
>
> Is there a means to enter directly hexadecimal number in an integer
> field in a table ? (I don't known by advance if the number is hexa
> ou decimal so I can't use a special function)
>
> Best regards.
>
>         Thierry
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-general by date:

Previous
From: Juan Jose Comellas
Date:
Subject: Problem with time in export
Next
From: Alejandro Fernandez
Date:
Subject: making a trigger to a system call to a shell script