------=_Part_77297_11597378.1164170768207
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/i...ns-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

------=_Part_77297_11597378.1164170768207
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,<br><br>&nbsp;&nbsp;&nbsp; On this page (<a href="http://www.postgresql.org/docs/8.1/interactive/functions-array.html">http://www.postgresql.org/docs/8.1/interactive/functions-array.html</a>), the entry for array_lower() says:<br>
Example:<br>&nbsp; <tt class="LITERAL">array_lower(array_prepend(0, ARRAY[1,2,3]), 1)</tt><br><br clear="all"><br>-- <br>gurjeet[.singh]@EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | yahoo }.com<br><br>

------=_Part_77297_11597378.1164170768207--

------=_Part_77349_14397706.1164171146435
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sorry, again, for an incomplete mail:

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/i...ons-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

------=_Part_77349_14397706.1164171146435
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sorry, again, for an incomplete mail:<br><br>Hi all,<br><br>&nbsp;&nbsp; &nbsp;On this page (<a href="http://www.postgresql.org/docs/8.1/interactive/functions-array.html">http://www.postgresql.org/docs/8.1/i...ons-array.html
</a> ), the entry for array_lower() says:<br><br>Example:<br><span style="font-family: courier new,monospace;">&nbsp; array_lower(array_prepend(0, ARRAY[1,2,3]), 1)</span><br style="font-family: courier new,monospace;">Result:
<br><span style="font-family: courier new,monospace;">&nbsp; 0</span><br style="font-family: courier new,monospace;"><br>But in this is the output that I am getting:<br><br><span style="font-family: courier new,monospace;">postgres=# select array_lower(array_prepend( 0, array[1,2,3] ), 1 );
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">&nbsp;array_lower</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
-------------</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp; 1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
(1 row)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">postgres=#</span><br style="font-family: courier new,monospace;">
<br>Is it a bug in array_lower, array or is it a doc error? I am on 8.2 Beta 1.<br><br>-- <br>gurjeet[.singh]@ EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | yahoo }.com<br><br>

------=_Part_77349_14397706.1164171146435--

------=_Part_77305_13411388.1164170830696
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sorry for an incomplete mail:

Hi all,

On this page (
http://www.postgresql.org/docs/8.1/i...ns-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

------=_Part_77305_13411388.1164170830696
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sorry for an incomplete mail:<br><br>Hi all,<br><br>&nbsp;&nbsp;&nbsp; On this page (<a href="http://www.postgresql.org/docs/8.1/interactive/functions-array.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.postgresql.org/docs/8.1/i...ons-array.html
</a>), the entry for array_lower() says:<br><br>
Example:<br>&nbsp; <tt>array_lower(array_prepend(0, ARRAY[1,2,3]), 1)<br>Result:<br><br></tt><span class="sg"></span><br clear="all"><span class="sg"></span><br><span class="sg">-- </span><br><span class="sg">gurjeet[.singh]@
EnterpriseDB.com</span><br><span class="sg">singh.gurjeet@{ gmail | hotmail | yahoo }.com</span><br><span class="sg"></span><br><span class="sg">

</span><br><br>

------=_Part_77305_13411388.1164170830696--

"Gurjeet Singh" <singh.gurjeet (AT) gmail (DOT) com> writes:
And?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

------=_Part_77513_441880.1164172536615
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 11/22/06, Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:
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

------=_Part_77513_441880.1164172536615
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 11/22/06, <b class="gmail_sendername">Tom Lane</b> &lt;<a href="mailto:tgl (AT) sss (DOT) pgh.pa.us">tgl (AT) sss (DOT) pgh.pa.us</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
&quot;Gurjeet Singh&quot; &lt;<a href="mailto:singh.gurjeet (AT) gmail (DOT) com">singh.gurjeet (AT) gmail (DOT) com</a>&gt; writes:<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; On this page (<br>&gt; <a href="http://www.postgresql.org/docs/8.1/interactive/functions-array.html">
http://www.postgresql.org/docs/8.1/interactive/functions-array.html</a>), the<br>&gt; entry for array_lower() says:<br>&gt; Example:<br>&gt;&nbsp;&nbsp; array_lower(array_prepend(0, ARRAY[1,2,3]), 1)<br><br>And?<br></blockquote></div>
<br>I had some problem with my GMail + Firefox, (after returning to GMail tab from another tab) pressing SPACE fired a send.<br><br>Apologize for extra traffic. Please refer to my mails sent after the above one.<br><br clear="all">
<br>-- <br>gurjeet[.singh]@EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | yahoo }.com

------=_Part_77513_441880.1164172536615--

"Gurjeet Singh" <singh.gurjeet (AT) gmail (DOT) com> writes:
Neither, it's an intentional change in the behavior of array_prepend().
You should be reading the 8.2 docs.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq