| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2006-06-17 19:33:17 | Re: Optimizer internals |
| Previous Message | Josh Berkus | 2006-06-17 19:19:40 | Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL |