pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (4+ messages)  latest in thread

Message-ID: <877lp4fkfb.fsf@tolikus.hq.aaanet.ru>
Permalink:  ../877lp4fkfb.fsf@tolikus.hq.aaanet.ru/
Also on:    postgresql.org/message-id/877lp4fkfb.fsf@tolikus.hq.aaanet.ru

 · 

reply

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