temporary tables - Mailing list pgsql-general

From Alfonso Peniche
Subject temporary tables
Date
Msg-id 3A89C0A6.271C1366@iteso.mx
Whole thread Raw
List pgsql-general
Since I cannot return a set of values (namely rows from a table) from a
function, I thought I could create a temporary table where I could place
the resulting information.

Unfortunately I have a big problem. If I create this table and run the
same procedure again (during the same session) I'll get a message saying
the table already exists, but there's no way I can drop this table from
plpgsql. Is there a way I can implement this?

Thanx.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Order question
Next
From: "Matt Friedman"
Date:
Subject: Re: SELECT (sometimes) returning Zero Rows?