From: Jeroen Olthof <j.olthof@millipede.nl>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: function return multiply rows
Date: Wed, 25 Sep 2002 09:17:02 +0200
Message-ID: <amrnt5$1ivj$1@news.hub.org> (raw)
What is going wrong here?
An example of what I'm trying to do.
vw_teams is a view but same problem when trying it on a single table
CREATE FUNCTION test() RETURNS SETOF vw_teams AS 'select * from vw_teams;'
LANGUAGE 'sql';
SELECT test();
results in
test
-----------
137789256
137789256
(2 rows)
and this is what I expect
team | datum
----------+------------
groenwit | 2002-07-09
ordenbos | 2002-09-14
(2 rows)
????
kind regard
Jeroen Olthof
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: j.olthof@millipede.nl, pgsql-general@postgresql.org
Subject: Re: function return multiply rows
In-Reply-To: <amrnt5$1ivj$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox