Re: Temp tables and functions

Thanks, Jim.  I'll give it a try.

On Tue, 2006-10-10 at 21:11 -0500, Jim C. Nasby wrote:
> On Tue, Oct 10, 2006 at 03:21:36PM -0400, mark.dingee@cox.net wrote:
> > Everyone,
> > 
> > I've written a function (language = sql) which uses a temporary table to simplify the process; however, when I go
toload the function I get:
 
> > 
> > /var/lib/pgsql$cat thm.sql | psql test
> > ERROR:  relation "lost_bus" does not exist
> > 
> > where "lost_bus" is the name of my temp table.  The function is just for a report that is run monthly, so I can
createa permanent table if necessary, but I'd rather not. 
 
> 
> Create the temp table in your script that creates the function. You
> don't need to populate it or anything, you just need it to exist
> (prefferably with the correct definition).