473,382 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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 1434

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Maniek | last post by:
Hi, Has anyone Pg linked to MSSQL or vice versa? I need to transfer some data MSSQL->PGSQL, but without writing a complex program. Maybe using Linked Server (MSSQL), ODBC / JDBC / OLE DB,...
2
by: Chris | last post by:
I think I already know that the answer is that this can't be done, but I'll ask anyways. Suppose you want to use an RDBMS to store messages for a threaded message forum like usenet and then...
8
by: Dennis Gearon | last post by:
How soon will 7.5 come out? (yes, I know, 7.4 is beta right now). How difficult is it to set up cygwin? I'd like to make a drop in Apache/Postgres/PHP application on a windows computer for...
20
by: Dennis Gearon | last post by:
I am working on a design where a location for something can have: Fully qualified address with even building names, room numbers, and booth numbers. **-OR-** GPS location **-OR-** Both ...
7
by: snpe | last post by:
Is it down ? regards ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's...
1
by: A. Mous | last post by:
Not sure if this is a win installer issue or Microsoft MDAC issue... I've installed the win32 pg8.0 beta2 dev3 along with the accompanying ODBC that is packaged with the installer. Works great,...
1
by: John French | last post by:
I just installed postgresql 7.4.5 and pgadmin3 1.0.2 on FreeBSD and noticed that pgadmin allows the pgsql user to log in while ignoring the password. You can enter a wrong password or no password...
7
by: Richard Marsden | last post by:
(also posted to microsoft.public.access.odbcclientsvr but no reply so far: problem concerns ODBC->MS Access) I have some ODBC code that I'm testing against various underlying databases. The...
3
by: scott.alfon | last post by:
Hello, i need your help. I want to implement using c/c++ where I can access to different database types as PostSQL, MySQL etc. The heterogenous databases are on different servers. Is that...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.