Re: [SQL] Function Temp Table Woes

2006-08-10 Thread Chad Voelker
Michael- Nice explaination of what was happening to the temp table. Thank you. -Chad --- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Aug 08, 2006 at 10:24:02AM -0700, Chad > Voelker wrote: > > The Goal: Return a set of records from one table > based > > on entries in a temporary table. I

Re: [SQL] Function Temp Table Woes

2006-08-08 Thread Michael Fuhr
On Tue, Aug 08, 2006 at 10:24:02AM -0700, Chad Voelker wrote: > The Goal: Return a set of records from one table based > on entries in a temporary table. I'd expect this to be > a commonly requested functionality. After reading the > docs, support lists and googling, I haven't come up > with a clea

[SQL] Function Temp Table Woes

2006-08-08 Thread Chad Voelker
Hello, I'm a newbie to plpgsql functions so any help I can get would be appreciated. I have a little bit of a history with MS SQL Server 2000, so this may be where I'm messed up ;) The Goal: Return a set of records from one table based on entries in a temporary table. I'd expect this to be a comm