function return multiply rows

From: "Jeroen Olthof" <j(dot)olthof(at)millipede(dot)nl>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: function return multiply rows
Date: 2002-09-25 07:17:02
Message-ID: amrnt5$1ivj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Adriaanse 2002-09-25 07:22:08 Web hosts
Previous Message Murali Mohan Kasetty 2002-09-25 07:03:17 Re: Administrator issue

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Tkach 2002-09-25 14:03:22 Re: database abstraction -> functions
Previous Message Manfred Koizar 2002-09-25 06:54:56 Re: [SQL] CURRENT_TIMESTAMP