473,544 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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_Ke ys"();
HCM_Primary_Key s

------------------
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 1439

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

Similar topics

2
2960
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, but have no experience with this kind of jobs.
2
2233
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 display the messages. A toy table definition (that I've tried to make standards compliant) might look like: create table messages ( message_id...
8
2134
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 someone in my organization. I'd PREFER to avoid ODBC if at all possible.
20
2080
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 Other than triggers, is there a way to enforce this using tables and
7
2288
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 datatypes do not match
1
1727
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, love it, and all the rest. My application uses ADO 2.7 to interface with the ODBC driver. My application frequently sends status e-mails to...
1
7185
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 and still get into postgresql. I started the postmaster as a FreeBSD user named pgsql by running postmaster -i -D /usr/local/pgsql/data I changed...
7
2546
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 code was developed against MySQL but now I'm getting other common options to work. I'm having trouble with Access - even the sample code (intended for...
3
1414
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 possible? Furthermore I want to include an access authorization which defines the write- or read-access of each user.
0
7431
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7370
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7617
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7779
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7714
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5920
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3424
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3415
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1848
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.