Re: [GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Jeff Davis
On Wed, 2006-09-20 at 17:29 -0400, Terry Lee Tucker wrote: > Well, I was assuming that that the table wasn't being dropped and that was > what was causing the error. I can see from your comments, that I was wrong on > that asssumption. I can do this with and execute, but it's going to be a pain

Re: [GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Terry Lee Tucker
Thanks for the reponse Jeff. See comments below. On Wednesday 20 September 2006 05:09 pm, Jeff Davis <[EMAIL PROTECTED]> thus communicated: --> On Wed, 2006-09-20 at 16:51 -0400, Terry Lee Tucker wrote: --> > Greetings: --> > --> > I have have a plpgsql function that creates a temporary table to

Re: [GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Jeff Davis
On Wed, 2006-09-20 at 16:51 -0400, Terry Lee Tucker wrote: > Greetings: > > I have have a plpgsql function that creates a temporary table to facilitate > some processing. Here is the code: > CREATE TEMP TABLE tmp (code VARCHAR, >booked INTEGER, >

[GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Terry Lee Tucker
Greetings: I have have a plpgsql function that creates a temporary table to facilitate some processing. Here is the code: CREATE TEMP TABLE tmp (code VARCHAR, booked INTEGER, availINTEGER, c