The following query doesn't return the version of PostgreSQL currently
running, but rather the version of initdb that initialized the cluster:
SELECT character_value
FROM information_schema.sql_implementation_info
WHERE implementation_info_name = 'DBMS VERSION';
Is that the intended or desired behavior?
sql_implementation_info is a table rather than a view, so its
contents are hardcoded by initdb. Would it make sense to turn it
into a view? This is admittedly a minor issue that might not merit
the effort, but it still seems wrong.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/