Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1E4DB47668E for ; Tue, 24 Sep 2002 09:51:10 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id A6766476670 for ; Tue, 24 Sep 2002 09:51:09 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 0B65BD619; Tue, 24 Sep 2002 06:51:10 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id F12A55C02; Tue, 24 Sep 2002 06:51:09 -0700 (PDT) Date: Tue, 24 Sep 2002 06:51:09 -0700 (PDT) From: Stephan Szabo To: Madhavi Cc: Subject: Re: arrays (was untitled) In-Reply-To: Message-ID: <20020924064806.B92621-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/300 X-Sequence-Number: 9577 On Tue, 24 Sep 2002, Madhavi wrote: > How do I pass an array as an aruments in a postgres function? And how do I > use it in the function?? Well, I've only got a 7.3devel machine to test, but: create function f(int[]) returns int as 'select $1[1];' language 'sql'; select f('{3,4}'); seems to work for example. What are you actually trying to do and in what language?