Postgres Pro
Downloads
Home   >   mailing lists

Re: Array as a parameter to stored procedure. - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Array as a parameter to stored procedure.
Date
Msg-id 20060111060006.GA17093@webserv.wug-glas.de
Whole thread Raw
In response to Array as a parameter to stored procedure.  (Sameer Nanda <sam504u@gmail.com>)
List pgsql-general
Tree view 
am  10.01.2006, um 11:19:32 -0500 mailte Sameer Nanda folgendes:
> Is it possible to accept an array (or any data structure representing an
> ordered set ) as an input parameter in a stored procedure? The
> number of elements will vary from call to call.

Yes, of course. A simple example:
http://a-kretschmer.de/tools/array_compare.sql


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: pgsql.waldvogel@mac.com
Date:
Subject: Connection specific information - Temporary table used in Sybase to store information
Next
From: "Gevik"
Date:
Subject: Recommend IDE for PG Development