Re: Version Number Function?

David E. Wheeler wrote:
> On Oct 11, 2008, at 19:57, Tom Lane wrote:
>
>> "David E. Wheeler" <david(at)kineticode(dot)com> writes:
>>> Any interest in adding a function like this to core?
>>
>> No, because it's already there: see "show server_version_num".
>>
>> (It's probably worth noting that none of our existing clients that would
>> have any use for this information look at server_version_num, because
>> it's only available in 8.2 and up. A function introduced as of 8.4
>> would be an additional two major releases behind the curve.)
>
> Yeah, but I want to use it in WHERE clauses or CASE statements. I'm fine
> to just include it in pgtap, though.

You could do:
select setting from pg_settings where name='server_version_num';

(wrapped in the appropriate subselect to use it in a WHERE clause)

//Magnus