X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09DAAD7ACF for ; Wed, 12 Oct 2005 03:50:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66929-02 for ; Wed, 12 Oct 2005 06:50:39 +0000 (GMT) Received: from hotmail.com (bay111-f35.bay111.hotmail.com [64.4.17.45]) by svr1.postgresql.org (Postfix) with ESMTP id BAE05D7AB9 for ; Wed, 12 Oct 2005 03:50:39 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 11 Oct 2005 23:50:40 -0700 Message-ID: Received: from 64.4.17.200 by by111fd.bay111.hotmail.msn.com with HTTP; Wed, 12 Oct 2005 06:50:40 GMT X-Originating-IP: [164.164.12.25] X-Originating-Email: [ashu_shri@hotmail.com] X-Sender: ashu_shri@hotmail.com In-Reply-To: <20051012061322.GA3592@winnie.fuhr.org> From: "ashish srivastava" To: mike@fuhr.org Cc: pgsql-admin@postgresql.org Subject: Re: Regarding array of parameter passing from application to the Date: Wed, 12 Oct 2005 12:20:40 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 12 Oct 2005 06:50:40.0755 (UTC) FILETIME=[427C5430:01C5CEF9] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.312 required=5 tests=[AWL=-0.438, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/130 X-Sequence-Number: 19202 i am using java to pass the parameter to the database and my client side lanugaue is flash. >From: Michael Fuhr >To: ashish srivastava >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] Regarding array of parameter passing from application >to the database >Date: Wed, 12 Oct 2005 00:13:22 -0600 > >On Tue, Oct 11, 2005 at 07:24:52PM +0530, ashish srivastava wrote: > > can anybody help me in passing an array of parameters to the postgresql > > functions. > >What functions? Server-side functions that you've created? What >argument types do those functions take? Arrays of some base type? > > > I am having multiple check boxes on the UI and searching in the database >on > > the basis whichever is the user selection criterion.. > >What client-side language are you using? How are you receiving the >checkbox choices? As an array with the selected elements? If your >API can't automatically create a PostgreSQL array from a client >language array, then you could build a string that represents the >array using one of the formats described in the "Arrays" section >of the PostgreSQL documentation: > >http://www.postgresql.org/docs/8.0/interactive/arrays.html > >If that's not what you're looking for then please provide more >information. > >BTW, this seems off-topic for pgsql-admin. Pgsql-interfaces, >pgsql-general, pgsql-novice, or perhaps pgsql-php (if you're using >PHP) would be more appropriate. > >-- >Michael Fuhr > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings _________________________________________________________________ Tata Racing is giving away racing goodies. Enter contest now. http://server1.msn.co.in/sp05/tataracing/contest.asp