Re: [SQL] Temp Tables Connection Pooling

2001-03-06 Thread Ian Harding
Gerald Gutierrez wrote: At 12:48 PM 3/2/2001 -0800, David Olbersen wrote: On Fri, 2 Mar 2001, Gerald Gutierrez wrote: -Recently I wanted to implement Dijkstra's algorithm as a stored procedure, -and finding that PL/PGSQL cannot return record sets, I thought about using -a temporary table

Re: [SQL] Temp Tables Connection Pooling

2001-03-03 Thread Richard Huxton
David Olbersen wrote: On Fri, 2 Mar 2001, Gerald Gutierrez wrote: -Recently I wanted to implement Dijkstra's algorithm as a stored procedure, -and finding that PL/PGSQL cannot return record sets, I thought about using -a temporary table for the results. If tempoary tables are

Re: [SQL] Temp Tables Connection Pooling

2001-03-03 Thread Gerald Gutierrez
At 12:48 PM 3/2/2001 -0800, David Olbersen wrote: On Fri, 2 Mar 2001, Gerald Gutierrez wrote: -Recently I wanted to implement Dijkstra's algorithm as a stored procedure, -and finding that PL/PGSQL cannot return record sets, I thought about using -a temporary table for the results. If tempoary

[SQL] Temp Tables Connection Pooling

2001-03-02 Thread Gerald Gutierrez
I use PostgreSQL via a connection pooling mechanism, whether it be J2EE or PHP. I've been able to achieve good performance this way, and it has been good to me. Recently I wanted to implement Dijkstra's algorithm as a stored procedure, and finding that PL/PGSQL cannot return record sets, I

Re: [SQL] Temp Tables Connection Pooling

2001-03-02 Thread David Olbersen
On Fri, 2 Mar 2001, Gerald Gutierrez wrote: -Recently I wanted to implement Dijkstra's algorithm as a stored procedure, -and finding that PL/PGSQL cannot return record sets, I thought about using -a temporary table for the results. If tempoary tables are session-specific, -however, then wouldn't