function return multiply rows - Mailing list pgsql-sql

From Jeroen Olthof
Subject function return multiply rows
Date
Msg-id amrnt5$1ivj$1@news.hub.org
Whole thread Raw
List 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
-----------137789256137789256
(2 rows)

and this is what I expect
  team   |   datum
----------+------------groenwit | 2002-07-09ordenbos | 2002-09-14
(2 rows)


????

kind regard

Jeroen Olthof





pgsql-sql by date:

Previous
From: Kevin Houle
Date:
Subject: Re: Dublicates pairs in a table.
Next
From: Gustavo Tadao Okida
Date:
Subject: PL/pgsql