A bug or documentation error?

Started by Gurjeet Singhover 19 years ago6 messagesbugs
Jump to latest
#1Gurjeet Singh
singh.gurjeet@gmail.com

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the
entry for array_lower() says:
Example:
array_lower(array_prepend(0, ARRAY[1,2,3]), 1)

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

#2Gurjeet Singh
singh.gurjeet@gmail.com
In reply to: Gurjeet Singh (#1)
Re: A bug or documentation error?

Sorry for an incomplete mail:

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the
entry for array_lower() says:

Example:
array_lower(array_prepend(0, ARRAY[1,2,3]), 1)
Result:

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

#3Gurjeet Singh
singh.gurjeet@gmail.com
In reply to: Gurjeet Singh (#2)
Re: A bug or documentation error?

Sorry, again, for an incomplete mail:

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/interactive/functions-array.html ), the
entry for array_lower() says:

Example:
array_lower(array_prepend(0, ARRAY[1,2,3]), 1)
Result:
0

But in this is the output that I am getting:

postgres=# select array_lower(array_prepend( 0, array[1,2,3] ), 1 );
array_lower
-------------
1
(1 row)

postgres=#

Is it a bug in array_lower, array or is it a doc error? I am on 8.2 Beta 1.

--
gurjeet[.singh]@ EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Gurjeet Singh (#1)
Re: A bug or documentation error?

"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:

On this page (
http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the
entry for array_lower() says:
Example:
array_lower(array_prepend(0, ARRAY[1,2,3]), 1)

And?

regards, tom lane

#5Gurjeet Singh
singh.gurjeet@gmail.com
In reply to: Tom Lane (#4)
Re: A bug or documentation error?

On 11/22/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:

"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:

On this page (
http://www.postgresql.org/docs/8.1/interactive/functions-array.html),

the

entry for array_lower() says:
Example:
array_lower(array_prepend(0, ARRAY[1,2,3]), 1)

And?

I had some problem with my GMail + Firefox, (after returning to GMail tab
from another tab) pressing SPACE fired a send.

Apologize for extra traffic. Please refer to my mails sent after the above
one.

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

#6Tom Lane
tgl@sss.pgh.pa.us
In reply to: Gurjeet Singh (#3)
Re: A bug or documentation error?

"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:

Is it a bug in array_lower, array or is it a doc error? I am on 8.2 Beta 1.

Neither, it's an intentional change in the behavior of array_prepend().
You should be reading the 8.2 docs.

regards, tom lane