X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D671FD1E9BE for ; Wed, 21 Jan 2004 14:03:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 32787-03 for ; Wed, 21 Jan 2004 10:03:04 -0400 (AST) Received: from trade-india.com (unknown [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id 3F22AD1E9C2 for ; Wed, 21 Jan 2004 10:02:41 -0400 (AST) Received: (qmail 2216 invoked from network); 21 Jan 2004 14:00:12 -0000 Received: from localhost (HELO trade-india.com) (127.0.0.1) by localhost with SMTP; 21 Jan 2004 14:00:12 -0000 Message-ID: <400E85EC.4000106@trade-india.com> Date: Wed, 21 Jan 2004 19:30:12 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: array_lower /array_prepend doubt Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/194 X-Sequence-Number: 16587 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.