Re: Function problem

Ahhhhhhhh. Thank you Josh. I just learned something new. I've been doing
it this way in MS SQL for years.

Patrick Hatcher
Macys.Com

"Josh Berkus"
<josh(at)agliodbs To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
.com> cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Function problem
03/15/2002
06:49 PM

Partrick,

> This a snippet of a much longer procedure. I am creating a cross-tab
> of
> sales data and dumping it into a temp table. A bunch of other temp
> tables
> are created and then the whole thing is put together in 1 table for
> reporting purposes. As stated earlier, it works if I don't put it
> into a
> function and I think it has to do with my quotes (").

No, the problem is that SELECT INTO in a procedure is for selecting
data into variables. PL/pgSQL is expecting a variable named "TEMP"
and not finding one. Instead, how about using the more standard
CREATE TABLE AS SELECT ... ?

-Josh Berkus