Re: pl/pgsql array return

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: "'Jose Luis LG'" <jlopezgonz(at)terra(dot)es>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: pl/pgsql array return
Date: 2002-02-13 14:44:40
Message-ID: 001901c1b49c$f7f968a0$8201a8c0@inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Jose,

What exactly are you trying to do? AFAIK postres can return a result
from a function like select sum(column) from table and the result will
be in a field named sum but as far as returning an array, I'm not sure.

Dave
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Jose Luis LG
Sent: Wednesday, February 13, 2002 9:25 AM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] pl/pgsql array return

Hi,

I hope someone can help me. Is it possible to return an array of
results from a query in a function in pl/pgsql and get this result via
the jdbc. Could someone send me an example of how this is done.


Thanks

Jose Luis

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter V. Cooper 2002-02-13 15:57:15 Re: problem with storing BLOBs larger then 2MB
Previous Message Jose Luis LG 2002-02-13 14:25:02 pl/pgsql array return