Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AD5649FB9D0 for ; Wed, 13 Jun 2007 09:55:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 70415-04 for ; Wed, 13 Jun 2007 09:55:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by postgresql.org (Postfix) with ESMTP id B6A3C9FB490 for ; Wed, 13 Jun 2007 09:55:15 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so146468wri for ; Wed, 13 Jun 2007 05:55:14 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lMa7LsIo9M3NOHZKZq9LjODUhYsCrT3BA5LhqzaX7ZO6Ucl0qXxC9I2dYbLCfyeBk/YCk8TgGL3K6TMcOpYZMPWXqbNBBuPzysyyUSEzNW3qf4JBntPnFG9ansG62os5sN3wjnyvmyvnMAwFF4h96EvhqBFCJSVFVRZLXgA/vUU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qiCaA6Nt7jEFNtR0zU5xVu1s0teBiCBFRjG/hTgLFfcOQSvcJId1F27PccPFHzZQpaKTokUHwYyWEpUfSGTjsxDYDwKRW46wjOGRSZE1HbhpHXFhiE7hkLMk3K3M5/zycfXoyWpv/8orqk9AGtOrc/kXuSjzxt9qNaTwjPGO0/4= Received: by 10.142.76.4 with SMTP id y4mr30298wfa.1181739313857; Wed, 13 Jun 2007 05:55:13 -0700 (PDT) Received: by 10.142.80.10 with HTTP; Wed, 13 Jun 2007 05:55:13 -0700 (PDT) Message-ID: <162867790706130555r5a1ba9cbq1c3e2cb0f1adbda7@mail.gmail.com> Date: Wed, 13 Jun 2007 14:55:13 +0200 From: "Pavel Stehule" To: "Jyoti Seth" Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <000001c7adb1$fb497360$f1dc5a20$@com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <000001c7adb1$fb497360$f1dc5a20$@com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/771 X-Sequence-Number: 115594 Hello maybe: create function foo(varchar[][]) returns void as $$ begin end$$ language plpgsql; postgres=# select foo(array[array[1,2], array[2,2]]::varchar[][]); foo ----- (1 row) Regards Pavel Stehule 2007/6/13, Jyoti Seth : > > > > > Hi, > > > > I have to pass a set of values and arrays in postgresql 8.2 functions. But I > am not getting any help on that. Please let me know if any one has idea. > > > > Thanks, > > Jyoti