Re: [HACKERS] Information Schema DBMS VERSION wrong

2005-08-03 Thread Peter Eisentraut
Am Freitag, 29. Juli 2005 06:28 schrieb Tom Lane: The following query doesn't return the version of PostgreSQL currently running, but rather the version of initdb that initialized the cluster: Not sure if it was really thought about, but seeing that (a) you can get the current version from

[HACKERS] Information Schema DBMS VERSION wrong

2005-07-28 Thread Michael Fuhr
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

Re: [HACKERS] Information Schema DBMS VERSION wrong

2005-07-28 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] writes: 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