470,647 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Return set different in pgsql and MS Access/ODBC

I need to know why MS Access/ODBC is reporting different results than
the one shown in psql.

I created a very simple function below:

------------------
CREATE OR REPLACE FUNCTION public."Return_Some_Text"()
RETURNS SETOF varchar AS
'DECLARE

BEGIN
return next \'HCM00101\';
return next \'HCM00102\';
return next \'HCM00104\';
return next \'HCM00112\';
return;
END;'
LANGUAGE 'plpgsql' VOLATILE;
------------------
When I use the function inside psql (it works):
testdb2=# select * from "HCM_Primary_Keys"();
HCM_Primary_Keys

------------------
HCM00101
HCM00102
HCM00104
HCM00112
(4 rows)

But when I use MS Access/ODBC with the same SQL statement:
I only see one row "HCM00101" when I'm expecting four rows back just
like in psql.
What can I do so that MS/Access/ODBC shows all four rows rather than
the first one?
Jared

Jul 19 '05 #1
0 1369

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Dennis Gearon | last post: by
20 posts views Thread by Dennis Gearon | last post: by
7 posts views Thread by snpe | last post: by
1 post views Thread by A. Mous | last post: by
3 posts views Thread by scott.alfon | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.