On Oct 14, 2008, at 08:33, David E. Wheeler wrote:
> Well, the C version I borrowed from dumpitils seems to work great.
> Any reason I shouldn't stay with that?
Also, here's a simpler SQL version, for those following along at home:
create or replace function pg_version_num() returns int language
SQL as $$ SELECT SUM( (string_to_array(current_setting('server_version'), '.'))
[i]::int * CASE i WHEN 1 THEN 10000 WHEN 2 THEN 100 ELSE 1 end )::int FROM generate_series(1, 3) AS gen(i);
$$;
CREATE FUNCTION
There must be a way to get string_to_array() to evaluate only once, yes?
Best,
David
