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.