From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
---|---|
To: | |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: What's the equivalent in PL/pgSQL |
Date: | 2005-01-27 16:10:45 |
Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB16592@neptun.sonorys.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
That's bad.
Is there really no ohter way?
So it takes TWO termoral tables. Or even more?
And it can't be just sql because theres more around that statement.
> -----Original Message-----
> From: Sean Davis [mailto:sdavis2(at)mail(dot)nih(dot)gov]
> Sent: Donnerstag, 27. Jänner 2005 14:57
> To: KÖPFERL Robert
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Fradkin | 2005-01-27 16:51:18 | hardware mod based on feedback from the list |
Previous Message | cpp | 2005-01-27 15:46:25 | Need SELECT rights to UPDATE/DELETE WHERE? |