Re: Version Number Function? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Version Number Function?
Date
Msg-id 0B482C37-19B8-4F05-94F2-86DA6625CE2C@kineticode.com
Whole thread Raw
In response to Re: Version Number Function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Version Number Function?
List pgsql-hackers
On Oct 12, 2008, at 14:11, Tom Lane wrote:

> You'd have to parse the result of version().

As I figured. This is what I'm trying:

pg_version_num(PG_FUNCTION_ARGS)
{
#ifdef PG_VERSION_NUM    PG_RETURN_INT32(PG_VERSION_NUM);
#else    /* Code borrowed from dumputils.c. */int            cnt;int            vmaj,            vmin,
vrev;
cnt = sscanf(PG_VERSION, "%d.%d.%d", &vmaj, &vmin, &vrev);
if (cnt < 2)    return -1;
if (cnt == 2)    vrev = 0;
PG_RETURN_INT32( (100 * vmaj + vmin) * 100 + vrev );
#endif

Best,

David



pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: New shapshot RPMs (Oct 11 2008) are ready for testing
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?