Re: Array as a parameter to stored procedure.

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Array as a parameter to stored procedure.
Date: 2006-01-11 06:00:06
Message-ID: 20060111060006.GA17093@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ===

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2006-01-11 06:24:35 Re: ./configure --with-openssl=path fails
Previous Message Jim Nasby 2006-01-10 23:55:15 Re: help with rules for system table