Re: [SQL] What's the equivalent in PL/pgSQL

2005-01-27 Thread Sean Davis
res more around that statement. I'm not sure what you mean. Which statement? -Original Message- From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 27. Jänner 2005 14:57 To: KÖPFERL Robert Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] What's the equivalent in PL/pgSQ

Re: [SQL] What's the equivalent in PL/pgSQL

2005-01-27 Thread KÖPFERL Robert
gt; To: KÖPFERL Robert > Cc: pgsql-sql@postgresql.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,

Re: [SQL] What's the equivalent in PL/pgSQL

2005-01-27 Thread Sean Davis
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

[SQL] What's the equivalent in PL/pgSQL

2005-01-27 Thread KÖPFERL Robert
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)