Re: [BUGS] BUG #2223: Misleading info in docs on volatility level of

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: dueyduey(at)freemail(dot)hu, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2223: Misleading info in docs on volatility level of
Date: 2006-01-31 22:40:15
Message-ID: 200601312240.k0VMeF020881@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Jim C. Nasby wrote:
> This was recently discussed on -docs and I believe a patch was applied
> to at least HEAD.

Yep, patch attached. Any improvements?

---------------------------------------------------------------------------

>
> On Mon, Jan 30, 2006 at 10:33:35AM +0000, dueyduey(at)freemail(dot)hu wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 2223
> > Logged by:
> > Email address: dueyduey(at)freemail(dot)hu
> > PostgreSQL version: 8.1
> > Operating system: linux
> > Description: Misleading info in docs on volatility level of functions
> > Details:
> >
> > Hi, all!
> > The documentation on how to and why declare a function STABLE or IMMUTABLE
> > is very laconic. It makes clear what promises I make when determining the
> > volatility of my functions but it fails to point out what exactly I can
> > expect in turn for my promises.
> > See also the discussion on bug#2150 on the pgsql-bugs list.
> > Thanks for bothering.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
> >
>
> --
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Attachment Content-Type Size
unknown_filename text/plain 2.0 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-01-31 22:59:18 Re: BUG #2226: Can't delete elements from Enterprise Architect
Previous Message Bruce Momjian 2006-01-31 22:24:32 Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ...

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-02-01 00:50:17 Re: [BUGS] BUG #2195: log_min_messages crash server when in
Previous Message Bruce Momjian 2006-01-31 22:24:32 Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ...