From: Pavel Stehule <pavel.stehule@gmail.com>
To: Manso Gomez, Ramon <rmgomez@indra.es>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
Date: Thu, 14 Jun 2007 09:41:29 +0200
Message-ID: <162867790706140041r7593b868s34f82d1c7fadb7ea@mail.gmail.com> (raw)
In-Reply-To: <12B09E52EF3AEF41AEF3D205BD4DF465012268E8@MADARRMAIL3.indra.es>
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
>
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: pavel.stehule@gmail.com, rmgomez@indra.es, pgsql-general@postgresql.org
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
In-Reply-To: <162867790706140041r7593b868s34f82d1c7fadb7ea@mail.gmail.com>
* 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