Search Postgresql Archives

Re: Interesting case of IMMUTABLE significantly hurting performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Apr 09, 2025 at 02:43:11PM -0700, Adrian Klaver wrote:
> On 4/9/25 14:21, Nico Williams wrote:
> > That to_char is not immutable is not documented though.  Though it's
> > clear when looking at the docs for the `jsonb_.*_tz()` functions.
> 
> From here:
> 
> https://www.postgresql.org/docs/current/catalog-pg-proc.html
> 
> select proname, provolatile, prosrc  from pg_proc where proname='to_char';
> [...]

I'm surprised to see that counted as docs, but good to know.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux