Re: HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE

On 1/10/06, Vasudeva, Rahul <[email protected]> wrote:
>
>
>
> Hi,
>
>
>
>     I am executing a stored procedure from an ASP page without any input =
parameters, in that stored procedure two sql queries are executed and the r=
esult is stored in a temporary table, now I want to retrieve the recordset =
of that temp table on the interface.
>
>
>
> There is an error every time on the Interface "Invalid Object"  , althoug=
h I am dropping the temp table explicitly ..
>
>
>
> Thanks & Regards
>
> Rahul Vasudeva.
>
>

As you have already notice, there are little people looking as this
list... that is because now that we have a native port to windows use
the cygwin version is deprecated... and i am suggesting you to do that
as soon as possible...

There other list you can write here: http://www.postgresql.org/community/li=
sts/

About your question the reason is that temp tables un functions must
be declared within a EXECUTE... something like:


CREATE FUNCTION ffoo() RETURNS void AS $$
DECLARE
         EXECUTE 'CREATE TEMP TABLE tmp_foo (fld int4)'
END;
$$ LANGUAGE 'plpgsql';





--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected] so that your
       message can get through to the mailing list cleanly