Linked by Eugenia Loli-Queru on Mon 21st Apr 2003 17:26 UTC
PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. "PostgreSQL is one of the best-managed open source projects out there" a friend-in-the-know told me about 2 years ago, so today we feature a mini-interview with five members of the PostgreSQL team about their plans on the popular DB.
Permalink for comment
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
One thing I have found a pain in the ass in Postgress is returning a result set from a stored proc.
In Firbird you just add output params and add a suspend statement. then in you dynamic SQL code on the client the stored proc is treated exactly like a table.
i.e.
CREATE PROCEDURE ADMIN_GET_USERS
RETURNS (THENAME VARCHAR(35))
AS
BEGIN
for select username from USERDATA into :THENAME do
SUSPEND;
END
select * from ADMIN_GET_USERS
Can Postgress do this? If it can maybe someone could show me how, as this is the big reason I don't use Postgres.