Re: 10.0 - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: 10.0
Date
Msg-id 2B02C1AD-DB41-49F9-A819-48A45DF88966@gmail.com
Whole thread Raw
In response to Re: 10.0  (Mark Dilger <hornschnorter@gmail.com>)
Responses Re: 10.0  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
> On Jun 20, 2016, at 8:53 AM, Mark Dilger <hornschnorter@gmail.com> wrote:
>
>
> This is not a plea for keeping the three part versioning system.  It's just
> a plea not to have a 2 part versioning system masquerading as a three
> part versioning system, or vice versa.

To clarify my concern, I never want to have to write code like this:
CASE WHEN pg_version eq '11.1' OR pg_version eq '11.0.1' THEN foo()       WHEN pg_version eq '11.2' OR pg_version eq
'11.0.2'THEN bar()    .... 
or
if (0 == strcmp(pg_version_string, "11.1") || 0 == strcmp(pg_version_string, "11.0.1"))    foo();else if (0 ==
strcmp(pg_version_string,"11.2") || 0 == strcmp(pg_version_string, "11.0.2"))    bar(); 

either in sql, perl, c, java, or anywhere else.  As soon as you have two different
formats for the version string, you get into this hell.  Yeah, ok, you may have
a sql level function for this, but I'm thinking about applications somewhat removed
from a direct connection to the database, where you can't be sure which format
you'll be handed.


mark


pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: 10.0
Next
From: "David G. Johnston"
Date:
Subject: Re: 10.0