Re: Planning error in dynamic string creation in plpgsql

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@gmail.com