Kerri Reno wrote:
> Adrian,
>
> I don't understand. Why do I need to use execute?
It's a Postgres shortcoming. It's fixed in 8.3 so if it annoys you too
much you can just upgrade.
> It runs fine the first
> time. The second time it bombs, because it's not seeing schedrec
> correctly. Which part should be in an execute query statement?
All sentences referring to the temp table.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.