From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Keith Fiske <keith(at)omniti(dot)com>, PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Planning error in dynamic string creation in plpgsql |
Date: | 2014-01-06 04:44:49 |
Message-ID: | 52CA34C1.9090904@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
Should have added to my previous post, that when I want to deal with
truly dynamic values I use plpythonu. plpgsql is very useful but it does
not like types changing under it. plpythonu deals with that better.
>
>
>
> --
> Keith Fiske
> Database Administrator
> OmniTI Computer Consulting, Inc.
> http://www.keithf4.com
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-01-06 04:49:57 | Re: Planning error in dynamic string creation in plpgsql |
Previous Message | Keith Fiske | 2014-01-06 04:43:12 | Re: Planning error in dynamic string creation in plpgsql |