pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Regarding array of parameter passing from application to the database
3+ messages / 2 participants
[nested] [flat]

* Regarding array of parameter passing from application to the database
@ 2005-10-11 13:54 ashish srivastava <ashu_shri@hotmail.com>
  2005-10-12 06:13 ` Re: Regarding array of parameter passing from application to the database Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 3+ messages in thread

From: ashish srivastava @ 2005-10-11 13:54 UTC (permalink / raw)
  To: pgsql-admin



Hi,

can anybody help me in passing an array of parameters to the postgresql 
functions.

I am having multiple check boxes on the UI and searching in the database on 
the basis whichever is the user selection criterion..

Thanks,
Ashish

_________________________________________________________________
NRIs, does your family in India need money urgently? Open an ICICI Bank NRI 
savings A/c 
http://creative.mediaturf.net/creatives/icicibank/ICICI_NRI_ERA.htm




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding array of parameter passing from application to the database
  2005-10-11 13:54 Regarding array of parameter passing from application to the database ashish srivastava <ashu_shri@hotmail.com>
@ 2005-10-12 06:13 ` Michael Fuhr <mike@fuhr.org>
  2005-10-12 06:50   ` Re: Regarding array of parameter passing from application to the ashish srivastava <ashu_shri@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Fuhr @ 2005-10-12 06:13 UTC (permalink / raw)
  To: ashish srivastava <ashu_shri@hotmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding array of parameter passing from application to the
  2005-10-11 13:54 Regarding array of parameter passing from application to the database ashish srivastava <ashu_shri@hotmail.com>
  2005-10-12 06:13 ` Re: Regarding array of parameter passing from application to the database Michael Fuhr <mike@fuhr.org>
@ 2005-10-12 06:50   ` ashish srivastava <ashu_shri@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: ashish srivastava @ 2005-10-12 06:50 UTC (permalink / raw)
  To: mike@fuhr.org; +Cc: pgsql-admin

i am using java to pass the parameter to the database and my client side 
lanugaue is flash.


>From: Michael Fuhr <mike@fuhr.org>
>To: ashish srivastava <ashu_shri@hotmail.com>
>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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-10-12 06:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-11 13:54 Regarding array of parameter passing from application to the database ashish srivastava <ashu_shri@hotmail.com>
2005-10-12 06:13 ` Michael Fuhr <mike@fuhr.org>
2005-10-12 06:50   ` Re: Regarding array of parameter passing from application to the ashish srivastava <ashu_shri@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox