Re: hexadecimal values

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