Returning back a resultset from a stored function

Hi,

I am looking at ways to return a resultset from a
stored function through ODBC.
My background is in Oracle and I have to implement a
new VB6 system using PostgreSQL.

I have found that "psqlodbc" does not support the
refcursor type.
I also investigated the following form: " select *
from somefunc(); ", but realized that this worked only
inside "PL/pgSQL", therefore could not be used
directly from SQL.

First: Are my assumptions correct?
Second: Does anyone know a way to accomplish what I am
trying to do? 

I would appreciate any thoughts on the subject.

Thank you,
Daniel


______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match