Re: [DOCS] Functions example results incorrect

2011-07-11 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> The sample results shown on this page assume that the server parameter >> bytea_output is set >> to escape (the traditional PostgreSQL format). > Please consider that the "traditional PostgreSQL format" is now not the > _default_ bytea_output format. I

Re: [DOCS] Functions example results incorrect

2011-07-11 Thread Bruce Momjian
Tom Lane wrote: > Thom Brown writes: > > On 1 July 2011 19:17, Tom Lane wrote: > >> Thom Brown writes: > >>> The quote literal example of quote_literal('O\'Reilly') doesn't work > >>> on my installation by default. > > >> Hmm, should we use an E'' literal there, or change the input to be > >> '

Re: [DOCS] Functions example results incorrect

2011-07-07 Thread Thom Brown
On 8 July 2011 00:16, Tom Lane wrote: > Also, I looked at the examples for binary strings, and decided that > converting the sample outputs to hex format would render the examples > a lot less readable (since the inputs are not shown in that format). > So instead I'm going to add this: > >   >  

Re: [DOCS] Functions example results incorrect

2011-07-07 Thread Tom Lane
Thom Brown writes: > On 1 July 2011 19:17, Tom Lane wrote: >> Thom Brown writes: >>> The quote literal example of quote_literal('O\'Reilly') doesn't work >>> on my installation by default. >> Hmm, should we use an E'' literal there, or change the input to be >> 'O''Reilly'?  The former would co

Re: [DOCS] Functions example results incorrect

2011-07-01 Thread Thom Brown
On 1 July 2011 19:17, Tom Lane wrote: > Thom Brown writes: >> It says that exp(1.0) yields 2.71828182845905. > > exp(1.0) invokes numeric exp() these days, but when the examples were > written, it would have invoked float8 exp().  At least on my machine, > float8 does give the cited results > > N

Re: [DOCS] Functions example results incorrect

2011-07-01 Thread Tom Lane
Thom Brown writes: > I've been looking at some of the functions listed in the docs and > noticed some apparent discrepancies. > This page of the docs doesn't seem to match real output for exp or ln: > http://www.postgresql.org/docs/9.0/static/functions-math.html > It says that exp(1.0) yields 2.

Re: [DOCS] Functions example results incorrect

2011-06-23 Thread Thom Brown
On 23 June 2011 10:46, Thom Brown wrote: > I've been looking at some of the functions listed in the docs and > noticed some apparent discrepancies. > > This page of the docs doesn't seem to match real output for exp or ln: > http://www.postgresql.org/docs/9.0/static/functions-math.html > > It says

[DOCS] Functions example results incorrect

2011-06-23 Thread Thom Brown
I've been looking at some of the functions listed in the docs and noticed some apparent discrepancies. This page of the docs doesn't seem to match real output for exp or ln: http://www.postgresql.org/docs/9.0/static/functions-math.html It says that exp(1.0) yields 2.71828182845905. Testing on 3