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@agliodbs To: "Patrick Hatcher" <PHatcher@macys.com>
.com> cc: pgsql-novice@postgresql.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