The following bug has been logged online:
Bug reference: 3979
Logged by: David Lee
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.6
Operating system: Ubuntu Feisty Server
Description:SELECT DISTINCT slow even on indexed column
Details:
\d x:
Column
Postgres version: 8.0.6
Operating system: Ubuntu GNU/Linux
I executed the following query while trying to build some date-conversion
functions for data that was represented as milliseconds since the Unix epoch:
davidl=# SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J MS');
to_ch
