From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Kristis Makris <kristis(dot)makris(at)datasoft(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Using the extract() function in plpgsql |
Date: | 2001-06-27 07:17:38 |
Message-ID: | 3B398892.D0001CDE@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
Kristis Makris wrote:
>
> Creating the temporary table first, and then inserting into it seems to
> be a *somehow* functional workaround. However, the function cannot be
> called again a second time during the same session, since the temporary
> table already exists. Is there a way a table can be created truly
> temporary, existing only within the scope of a plpgsql function?
You could drop the temporary table at the end of the function, or do you
need something more than that?
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2001-06-27 08:51:20 | Re: Programming Languages |
Previous Message | Jie Liang | 2001-06-27 06:57:06 | session detect and terminate |
From | Date | Subject | |
---|---|---|---|
Next Message | David M. Richter | 2001-06-27 11:51:29 | Re: Plsql Function with error: No space left on device. |
Previous Message | Jie Liang | 2001-06-27 06:57:06 | session detect and terminate |