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
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 |