On 01/05/2014 08:34 PM, Keith Fiske wrote:
Actually, that doesn't work right. Gives weird results when the column is an integer Example: keith=# select min(col1), max(col1) from partman_test.time_static_table_p2014_01_01; min | max -----+----- 86 | 100 (1 row) keith=# select min(col1::text), max(col1::text) from partman_test.time_static_table_p2014_01_01; min | max -----+----- 100 | 99 (1 row)
Because it is working on a string in the second case. In the function remove the quote_literal() and see if that works.
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
