dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2223: Misleading info in docs on volatility level of functions in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default [BUGS] BUG #2223: Misleading info in docs on volatility level of functions - 01-30-2006 , 07:35 AM







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

Reply With Quote
  #2  
Old   
Jim C. Nasby
 
Posts: n/a

Default Re: [BUGS] BUG #2223: Misleading info in docs on volatility level of functions - 01-30-2006 , 06:33 PM






This was recently discussed on -docs and I believe a patch was applied
to at least HEAD.

On Mon, Jan 30, 2006 at 10:33:35AM +0000, dueyduey (AT) freemail (DOT) hu wrote:
Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.