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