Skip site navigation (1) Skip section navigation (2)

array_lower /array_prepend doubt

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: array_lower /array_prepend doubt
Date: 2004-01-21 14:00:12
Message-ID: 400E85EC.4000106@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-sql

Greetings!

can anyone explain why
 SELECT 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.


Responses

pgsql-sql by date

Next:From: Stephan SzaboDate: 2004-01-21 15:53:11
Subject: Re: array_lower /array_prepend doubt
Previous:From: Tomasz MyrtaDate: 2004-01-21 11:36:18
Subject: Re: time series data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group