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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org