array_lower /array_prepend doubt - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject array_lower /array_prepend doubt
Date
Msg-id 400E85EC.4000106@trade-india.com
Whole thread Raw
Responses Re: array_lower /array_prepend doubt
Re: array_lower /array_prepend doubt
List pgsql-sql

Greetings!

can anyone explain whySELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1);
returns 0 not 1

because

tradein_clients=# SELECT array_prepend(0, ARRAY[1,2,3]);
+---------------+
| array_prepend |
+---------------+
| {0,1,2,3}     |
+---------------+
(1 row)



and

tradein_clients=# SELECT array_lower( ARRAY[0,1,2,3],1 );
+-------------+
| array_lower |
+-------------+
|           1 |
+-------------+
(1 row)

Time: 402.614 ms


Regds
Mallah.



pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: time series data
Next
From: Stephan Szabo
Date:
Subject: Re: array_lower /array_prepend doubt