Skip site navigation (1) Skip section navigation (2)

Re: Precomputed constants?

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu>
Cc: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Precomputed constants?
Date: 2006-06-17 19:25:14
Message-ID: EB941076-A8B1-4A44-94A9-0BDAC2631FF9@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Jun 15, 2006, at 1:19 PM, Zoltan Boszormenyi wrote:
> # select distinct provolatile from pg_proc;
> provolatile
> -------------
> i
> s
> v
> (3 sor)
>
> If I get this right, IMMUTABLE/STABLE/VOLATILE
> are indicated with their initials.

That's probably correct. If the docs don't specify this then the code  
would. Or you could just create 3 test functions and see what you end  
up with, but I can't see it being any different from your guess.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



In response to

pgsql-performance by date

Next:From: Jim NasbyDate: 2006-06-17 19:33:17
Subject: Re: Optimizer internals
Previous:From: Josh BerkusDate: 2006-06-17 19:19:40
Subject: Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group