dbTalk Databases Forums  

return set different in psql and MS Access/ODBC

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss return set different in psql and MS Access/ODBC in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jarednevans@yahoo.com
 
Posts: n/a

Default return set different in psql and MS Access/ODBC - 08-17-2004 , 11:46 AM






I need to know why MS Access/ODBC is reporting different results than
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 4 rows back just like
in psql.

What can I do so that MS/Access/ODBC shows all 4 rows rather than the
first one?

Jared


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.