Re: New variable server_version_num

On Tue, Aug 01, 2006 at 04:25:00PM -0400, Christopher Browne wrote:
> ?column? | setting
> ----------+---------
> 5432 | 7.4.13
> (1 row)
>
> ?column? | setting
> ----------+---------
> 5533 | 7.4.10
> (1 row)
>
> ?column? | setting
> ----------+---------
> 5532 | 8.0.5
> (1 row)
>
> ?column? | setting
> ----------+----------
> 5882 | 8.2devel
> (1 row)
>
> If I wanted to, it oughtn't be difficult to "string smash" those
> settings into something very nearly useful...

It may or may not be difficult, depending on your definition of
'difficult,' but it's very easy and reproducible to get something that
can be cast to integer and compared that way. The existence of
version-number-comparison libraries like version.pm points to the idea
that it is, in fact, difficult to compare versions in general.

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

Remember to vote!