[SQL] problem with temporary table.

2003-07-12 Thread Vijay Kumar
Hi,     We are using postgresql7.3.3, we are encountering some problems by using temporary tables.   Actually our requirement was,         1. create temporary table.         2. insert some values on that table by using some quries.     3. select the inserted values from the temporary ta

[SQL] Problem with temporary table -- Urgent

2003-07-11 Thread Vijay Kumar
Hi, We are using postgresql 7.3.3, we are encountering the following problems when we used temporary tables.   Here with i'm sending my Sample function.   create or replace function TestTemp_refcur(refcursor) returns refcursor As 'declare refc alias for $1;    lString Varchar(4000);be