Re: [GENERAL] [SQL] function return multiply rows

2002-09-28 Thread Alvaro Herrera
En Fri, 27 Sep 2002 09:44:55 -0700 Joe Conway <[EMAIL PROTECTED]> escribió: > Jeroen Olthof wrote: > > 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(); >

Re: [SQL] function return multiply rows

2002-09-27 Thread Joe Conway
Jeroen Olthof wrote: > 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 >

[SQL] function return multiply rows

2002-09-27 Thread Jeroen Olthof
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 (