Re: [SQL] Problem with temporary table -- Urgent

2003-07-19 Thread Stephan Szabo
On Thu, 10 Jul 2003, Vijay Kumar wrote: > 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 > re

Re: [SQL] problem with temporary table.

2003-07-16 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 10 July 2003 03:03, Vijay Kumar wrote: > 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

[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

Re: [SQL] Problem with temporary table -- Urgent

2003-07-12 Thread Richard Huxton
On Thursday 10 Jul 2003 9:39 am, Vijay Kumar wrote: > 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 [snip]

[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