From: Manso Gomez, Ramon <rmgomez@indra.es>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
Date: Thu, 14 Jun 2007 09:03:48 +0200
Message-ID: <12B09E52EF3AEF41AEF3D205BD4DF465012268E8@MADARRMAIL3.indra.es> (raw)
In-Reply-To: <003401c7ae49$d21007a0$763016e0$@com>
References: <000001c7adb1$fb497360$f1dc5a20$@com>
<162867790706130555r5a1ba9cbq1c3e2cb0f1adbda7@mail.gmail.com>
<003201c7ae47$7ff80460$7fe80d20$@com>
<162867790706132257v53da9fb7raebee4f4ed50e00e@mail.gmail.com>
<003401c7ae49$d21007a0$763016e0$@com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmgomez@indra.es, pgsql-general@postgresql.org
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
In-Reply-To: <12B09E52EF3AEF41AEF3D205BD4DF465012268E8@MADARRMAIL3.indra.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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