Re: FW: Re: create temp in function

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kerri Reno <kreno(at)yumaed(dot)org>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: FW: Re: create temp in function
Date: 2008-04-21 23:16:38
Message-ID: 20080421231638.GE16040@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2008-04-21 23:20:22 Re: FW: Re: create temp in function
Previous Message Kerri Reno 2008-04-21 23:12:25 Re: FW: Re: create temp in function