Everyone,
I've written a function (language = sql) which uses a temporary table to
simplify the process; however, when I go to load 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 create a permanent table if necessary, but
I'd rather not.
Thanks in advance
Mark
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
