Can a function return a record set?

Am I correct in concluding that I can't return a record set from a function?

For example, in MS SQL I would do:

create procedure foo as
select * from yada

I expected to be able to do the following in postgresql.

create function foo (integer) returns (integer) as '
begin
select * from yada;
end; '
language 'plpgsql';

I am concluding that I can't.

jt