Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/pgsql array return - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: pl/pgsql array return
Date
Msg-id 001901c1b49c$f7f968a0$8201a8c0@inspiron
Whole thread Raw
In response to pl/pgsql array return  ("Jose Luis LG" <jlopezgonz@terra.es>)
Responses Re: pl/pgsql array return
List pgsql-jdbc
Tree view
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@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Jose Luis LG
Sent: Wednesday, February 13, 2002 9:25 AM
To: pgsql-jdbc@postgresql.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

 

pgsql-jdbc by date:

Previous
From: "Jose Luis LG"
Date:
Subject: pl/pgsql array return
Next
From: "Peter V. Cooper"
Date:
Subject: Re: problem with storing BLOBs larger then 2MB