Re: [SQL] Problem with Temp Table and Result Set from PL Function...

2007-02-21 Thread devil live
I solved the problem as select * from MYFUNC(); instead of select MYFUNC(); From: "devil live" <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Subject: [SQL] Problem with Temp Table and Result Set from PL Function... Date: Wed, 21 Feb 2007 11:31:02 + When I run fo

[SQL] Problem with Temp Table and Result Set from PL Function...

2007-02-21 Thread devil live
When I run following Function with the following SETOF table... it says: NOTICE: table "temp_production_product_operations" does not exist, skipping CONTEXT: SQL statement "drop table if exists temp_production_product_operations " PL/pgSQL function "pb_report_temp_gerceklesme12" line 11 at