Temp tables and functions - Mailing list pgsql-sql

From
Subject Temp tables and functions
Date
Msg-id 398587.1160508096610.JavaMail.root@eastrmwml06.mgt.cox.net
Whole thread Raw
Responses Re: Temp tables and functions  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-sql
Everyone,

I've written a function (language = sql) which uses a temporary table to simplify the process; however, when I go to
loadthe 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 create
apermanent table if necessary, but I'd rather not. 
 

Thanks in advance
Mark


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: i have table
Next
From: "Aaron Bono"
Date:
Subject: Re: optimal insert