Stored procedures from MS Query - Mailing list pgsql-general

From Tomas Larsson
Subject Stored procedures from MS Query
Date
Msg-id 20031028103653.56852.qmail@web41205.mail.yahoo.com
Whole thread Raw
Responses Re: Stored procedures from MS Query  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
List pgsql-general
Hi!

We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:

select * from getStudents()

(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
getStudents was a table, and complains that there is
no table called getStudents(). How do we get around
this?

We would be very grateful for any help!

/tomas, Patrik and Siv.


__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/

pgsql-general by date:

Previous
From: "Ben Johnson"
Date:
Subject: (OT)Open Source software training
Next
From: Shridhar Daithankar
Date:
Subject: Re: Stored procedures from MS Query