From: | Jeremy Drake <pgsql(at)jdrake(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: hex integer input |
Date: | 2007-03-02 07:57:28 |
Message-ID: | Pine.BSO.4.64.0703012345540.18849@resin.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 2 Mar 2007, Tom Lane wrote:
> Jeremy Drake <pgsql(at)jdrake(dot)com> writes:
> > On several occasions I have wanted to input integers in hexadecimal rather
> > than in decimal in PostgreSQL. I notice that there is a to_hex function,
> > but there is not (AFAIK) a way to provide an integer in hexadecimal.
>
> regression=# select x'abcd'::int;
> int4
> -------
> 43981
> (1 row)
Hmm. I actually used the bit(N) type on a project quite some time ago,
but it did not occur to me to use the bit string input syntax to input an
integer.
Well, I guess there is a way after all. So in the immortal words of Emily
Litella, "Never mind."
--
In an organization, each person rises to the level of his own
incompetency
-- The Peter Principle
From | Date | Subject | |
---|---|---|---|
Next Message | Vishal Arora | 2007-03-02 08:54:07 | xlogViewer / xlogdump |
Previous Message | Tom Lane | 2007-03-02 07:38:34 | Re: hex integer input |