Skip site navigation (1) Skip section navigation (2)

Re: New variable server_version_num

From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Greg Sabino Mullane <greg(at)turnstep(dot)com>,pgsql-patches(at)postgresql(dot)org
Subject: Re: New variable server_version_num
Date: 2006-07-30 16:04:04
Message-ID: 20060730160404.GR2654@fetter.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
On Sun, Jul 30, 2006 at 11:27:33AM -0400, Tom Lane wrote:
> David Fetter <david(at)fetter(dot)org> writes:
> > On Sat, Jul 29, 2006 at 09:44:10PM -0400, Tom Lane wrote:
> >> The correct solution is for client-side libraries to provide the
> >> feature.
> 
> > Not if the app is written in SQL, as the bootstrap, regression
> > test, etc. code for modules frequently is.
> 
> SQL doesn't really have any conditional ability strong enough to
> deal with existence or non-existence of features.  What are you
> hoping to do, a CASE expression?  Both arms of the CASE still have
> to parse, so I remain unconvinced that there are real world uses.

Failure to parse means the transaction bails out, which is just what I
want in my case, as it disallows people attempting to run the
programs--they're for DBI-Link--on too early a version of PostgreSQL.
As there are some subtleties to the implementation, I need something
that quickly returns boolean or fails entirely when it detects same.

Cheers,
D
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

Responses

pgsql-hackers by date

Next:From: Jonah H. HarrisDate: 2006-07-30 16:17:57
Subject: Re: New variable server_version_num
Previous:From: Tom LaneDate: 2006-07-30 15:44:44
Subject: Re: Going for "all green" buildfarm results

pgsql-patches by date

Next:From: Jonah H. HarrisDate: 2006-07-30 16:17:57
Subject: Re: New variable server_version_num
Previous:From: Tom LaneDate: 2006-07-30 15:27:33
Subject: Re: New variable server_version_num

pgsql-general by date

Next:From: Jonah H. HarrisDate: 2006-07-30 16:17:57
Subject: Re: New variable server_version_num
Previous:From: Tom LaneDate: 2006-07-30 16:00:55
Subject: Re: Joining dates/times (was Re: Splitting Timestamps)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group