Skip site navigation (1) Skip section navigation (2)

Re: array of composite types to refcusor

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: aasat <aasat(at)o2(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: array of composite types to refcusor
Date: 2008-05-27 17:38:14
Message-ID: b42b73150805271038i56252b9by9b1bedf0fa9b7f5c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, May 27, 2008 at 4:48 AM, aasat <aasat(at)o2(dot)pl> wrote:
> hello
>
> It is posibile to get data from array of composite types to refcursor?
>
> In oracle like this
>
> open c_refcur for
>   select * from TABLE(array_of_composite_types);

sure. AIUI, there is nothing that arrays of composites does any
differently from any other query in terms of how things work with
refcursors.  You pull data out with 'fetch', etc.  Since fetch is a
one-way ticket to the client, you will be limited to what the client
side interface library supports in terms of pulling data out of
composite arrays (worst case scenario you basically parse it out as
text).

I will humbly submit that our project, libpqtypes, is an attempt to
provide richer support for arrays and composites in the client side:
http://libpqtypes.esilo.com/

merlin

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2008-05-27 17:44:30
Subject: Re: Permission Problem for DELETE
Previous:From: Volkan =?utf-8?B?WWF6xLFjxLE=?=Date: 2008-05-27 17:23:35
Subject: Re: Permission Problem for DELETE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group