temporary tables

From: Alfonso Peniche <alfonso(at)iteso(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: temporary tables
Date: 2001-02-13 23:17:59
Message-ID: 3A89C0A6.271C1366@iteso.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Mike Castle 2001-02-13 23:18:16 Re: Re: Order question
Previous Message Hiroshi Inoue 2001-02-13 23:10:38 Re: Re: numeric type and odbc from access 2000