DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=hmnJW/qYJyVCp+SPaccq10fcGegwO69f4Se6n4eo0WYeK+RlY0fu41MTMm65uoFtwi9AB04+N79vMMFMC5KrBpjsfG4vfBVL64MX3R4CqUjp+i4n0Cmjlkm9X0k/jIg9tqxLOwMaZ2pMWtN8sVDxmBEnVvS6NKyk4Su3l0bXwp8=
Message-ID: <162867790706140041r7593b868s34f82d1c7fadb7ea@mail.gmail.com>
Date: Thu, 14 Jun 2007 09:41:29 +0200
From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: "Manso Gomez, Ramon" <rmgomez@indra.es>
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2
	functions
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
In-Reply-To: <12B09E52EF3AEF41AEF3D205BD4DF465012268E8@MADARRMAIL3.indra.es>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <000001c7adb1$fb497360$f1dc5a20$@com>
	<162867790706130555r5a1ba9cbq1c3e2cb0f1adbda7@mail.gmail.com>
	<003201c7ae47$7ff80460$7fe80d20$@com>
	<162867790706132257v53da9fb7raebee4f4ed50e00e@mail.gmail.com>
	<003401c7ae49$d21007a0$763016e0$@com>
	<12B09E52EF3AEF41AEF3D205BD4DF465012268E8@MADARRMAIL3.indra.es>

visit http://www.postgresql.org/community/lists/subscribe

2007/6/14, Manso Gomez, Ramon <rmgomez@indra.es>:
>  How can delete my suscription to this forums?
>
> -----Mensaje original-----
> De: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] En nombre de Jyoti Seth
> Enviado el: jueves, 14 de junio de 2007 8:04
> Para: 'Pavel Stehule'
> CC: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
> Asunto: Re: [SQL] setof or array as input parameter to postgresql 8.2
> functions
>
> Thanks a lot.
>
> Regards,
> Jyoti
>
> -----Original Message-----
> From: Pavel Stehule [mailto:pavel.stehule@gmail.com]
> Sent: Thursday, June 14, 2007 11:27 AM
> To: Jyoti Seth
> Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
> Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2
> functions
>
> 2007/6/14, Jyoti Seth <jyotiseth2001@gmail.com>:
> > Thanks for the solution. With this I am able to pass arrays and
> > multidimensional arrays in postgresql functions.
> >
> > One of my problem is still left I want to pass set of values with
> different
> > datatypes.For eg:
> > I want to pass following values to the function:
> > 1 ajay 1000.12
> > 2 rita 2300.24
> > 3 leena 1230.78
> > 4 jaya 3432.45
> >
> > As the values have different data types I have to create three
> > different arrays. Is there any way with which I can pass this as a
> > single setof values.
> >
> >
>
> You have to wait for 8.3 where arrays on composite types are supported.
> Currently in one our application we use array of arrays where different
> types are too, and we cast it to text.
>
> Regards
> Pavel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>