Re: FW: Re: create temp in function - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: FW: Re: create temp in function
Date
Msg-id 20080421231638.GE16040@alvh.no-ip.org
Whole thread Raw
In response to Re: FW: Re: create temp in function  ("Kerri Reno" <kreno@yumaed.org>)
List 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.

pgsql-general by date:

Previous
From: "Kerri Reno"
Date:
Subject: Re: FW: Re: create temp in function
Next
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: Re: FW: Re: create temp in function