Re: Suggestions please: names for function

mlw <markw@mohawksoft.com>

From: mlw <markw@mohawksoft.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2002-04-03T16:46:37Z
Lists: pgsql-hackers
Peter Eisentraut wrote:
> 
> Tom Lane writes:
> 
> > mlw <markw@mohawksoft.com> writes:
> > > (1) const or constant
> > > (2) cacheable
> > > (3) volatile
> >
> > I was wondering about "const" for case 1, also.  I think there is some
> > precedent for using "const" with this meaning in other programming
> > languages.
> 
> I think the meaning of "const" tends to be "cannot change the result" --
> which may actually make sense in SQL in a future life if you can pass
> around table descriptors or cursor references.

A function, such as sin(x) could be considered constant for the result based on
value 'x'