Thread: hex integer input
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. I have written a pure-sql implementation of some functions to input integers in hexadecimal (http://postgresql.jdrake.com/hex-int-in.sql.html), but it is less than efficient ;) Is there some reason why hex input is not currently supported? What would be the preferred way to implement it? 1. A function (or one for each int[248]), essentially from_hex(text) 2. Support in the input functions for int[248] for integers that start with '0[Xx]' as with strtol with base set to 0. 3. Support in the grammar for integral constants 0[Xx][0-9A-Fa-f]+ Thoughts? Is this a legitimate TODO? -- Mr. Cole's Axiom:The sum of the intelligence on the planet is a constant; thepopulation is growing.
Jeremy Drake <pgsql@jdrake.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)
regards, tom lane
On Fri, 2 Mar 2007, Tom Lane wrote: > Jeremy Drake <pgsql@jdrake.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
Hi Does anyone has an idea how xlogdump works with Windows installation of Postgres. I have postgres 8.2.x installed on my windows PC. How do we install it on Linux box with existing postgres 8.2.x installation Thanks Vishal _________________________________________________________________ Find a local pizza place, movie theater, and more�.then map the best route! http://maps.live.com/?icid=hmtag1&FORM=MGAC01
I am getting a following error while make install for xlogdump - [root@localhost xlogdump]# make install gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing xlogdump.o .../../src/port/sprompt.o ../../src/backend/utils/hash/pg_crc.o -L../../src/port -lpgport -L../../src/interfaces/libpq -lpq -L../../src/port -Wl,-rpath,'/usr/local/pgsql/lib' -lpgport-lz -lreadline -ltermcap -lcrypt -ldl -lm -o xlogdumpxlogdump.o(.text+0x163f): In function `dumpXLog': : undefined reference to `__stack_chk_fail' collect2: ld returned 1 exit status make: *** [xlogdump] Error 1 Please anyone can help in the same >From: "Vishal Arora" <aroravishal22@hotmail.com> >To: pgsql-hackers@postgresql.org >Subject: [HACKERS] xlogViewer / xlogdump >Date: Fri, 02 Mar 2007 08:54:07 +0000 > > >Hi > >Does anyone has an idea how xlogdump works with Windows installation of >Postgres. >I have postgres 8.2.x installed on my windows PC. > > >Thanks > >Vishal > >_________________________________________________________________ >Find a local pizza place, movie theater, and more�.then map the best route! >http://maps.live.com/?icid=hmtag1&FORM=MGAC01 > > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings _________________________________________________________________ With tax season right around the corner, make sure to follow these few simple tips. http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMFebtagline
On 3/2/07, Vishal Arora <aroravishal22@hotmail.com> wrote: > I am getting a following error while make install for xlogdump - For some reason, Diogo kept his already-built code in there, so you need to do a make clean && make install -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/