Re: What's the equivalent in PL/pgSQL

See this section of the manual:

http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
structures.html

In particular, look at 35.7.1.2 and 35.7.4. I think you need to loop
through the results of the query in order to return them. If you just
want to return the result set as a whole to another function that needs
to work with the data, you can use a cursor.

Sean

On Jan 27, 2005, at 7:46 AM, KÖPFERL Robert wrote:

> Hi,
> I'm trying to find an equivalent plpgsql function as this:
>
> func x returns SETOF "Tablename" AS
> '
> Select * from "Tablename";
> ' language sql
>
>
> How is this accomplished with plpgsql while not using a loop or a
> second and
> third temporal table?
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org