| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |