pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding 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>
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-12 06:13 Michael Fuhr <mike@fuhr.org>
parent: 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-12 06:50 ashish srivastava <ashu_shri@hotmail.com>
parent: Michael Fuhr <mike@fuhr.org>
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