Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Mon, 21 Apr 2008 19:16:38 -0400
  • Message-id: <20080421231638(dot)GE16040(at)alvh(dot)no-ip(dot)org>

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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group