David E. Wheeler wrote: > On Oct 11, 2008, at 19:57, Tom Lane wrote: > >> "David E. Wheeler" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
