From: tolik@icomm.ru
To: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] converting from number to text
Date: 16 Jun 1999 15:34:48 +0400
Message-ID: <877lp4fkfb.fsf@tolikus.hq.aaanet.ru> (raw)
References: <Pine.GS4.4.02A.9906161125380.13802-100000@netra.gdansk.sprint.pl>
>>>>> "fRS" == Remigiusz Sokolowski <rems@gdansk.sprint.pl> writes:
fRS> Hi!
fRS> I need convert number(float or integer) to text, but my version of
fRS> postgres (i.e. 6.3.2) seems to have not such a function?
fRS> Is it may be in newer versions or is there any work-around?
fRS> TIA
fRS> Rems
fRS> p.s. concept is to have field, which contain date in timestamp form
fRS> (number of seconds from 'epoch'), but in which I could insert also value
fRS> 'until cancellation' or any other text.
I send text of four function for int|float <-> text conversion.
==============================
Headers of the functions (you must replace DESTLIB to the real name of
your .so file):
void * text2float(text *t);
/*sql create function text2float(text) returns float as 'DESTLIB' language 'c'*/
text* float2text(float8 *f, int prec);
/*sql create function float2text(float, int) returns text as 'DESTLIB' language 'c'*/
int4 text2int(text* t);
/*sql create function text2int(text) returns int as 'DESTLIB' language 'c'*/
text* int2text(int4 i);
/*sql create function int2text(int) returns text as 'DESTLIB' language 'c'*/
===============================
Bodies of the functions:
void * text2float(text *t)
{
int l;
char *c;
float8 * ret;
if(!t)
return NULL;
l = VARSIZE(t) - VARHDRSZ + 1;
c = palloc(l);
memset(c, 0, l);
memcpy(c, VARDATA(t), l);
ret = palloc(sizeof(float8));
*ret = strtod(c, NULL);
return ret;
}
text* float2text(float8 *f, int prec)
{
char s[40];
char fmt[10];
text* ret;
int l;
if(!f)
return NULL;
sprintf(fmt, "%%.%dlf", prec);
sprintf(s, fmt, *f);
l = VARHDRSZ + strlen(s);
ret = palloc(l);
VARSIZE(ret) = l;
memcpy(VARDATA(ret), s, strlen(s));
return ret;
}
int4 text2int(text* t)
{
char* buf;
int l;
if (!t)
return 0;
l = VARSIZE(t) - VARHDRSZ;
buf = palloc(l + 1);
memset(buf, 0, l + 1);
memcpy(buf, VARDATA(t), l);
return atoi(buf);
}
text* int2text(int4 i)
{
text *ret;
char s[20];
int l;
sprintf(s, "%d", i);
l = VARHDRSZ + strlen(s);
ret = palloc(l);
VARSIZE(ret) = l;
memcpy(VARDATA(ret), s, l - VARHDRSZ);
return ret;
}
===============================
--
Anatoly K. Lasareff Email: tolik@icomm.ru
Senior programmer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tolik@icomm.ru, rems@gdansk.sprint.pl
Subject: Re: [SQL] converting from number to text
In-Reply-To: <877lp4fkfb.fsf@tolikus.hq.aaanet.ru>
References: <Pine.GS4.4.02A.9906161125380.13802-100000@netra.gdansk.sprint.pl> <877lp4fkfb.fsf@tolikus.hq.aaanet.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox