Thread: A bug or documentation error?

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

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

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

"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

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

"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