Re: [ADMIN] how to call sql code without function

2007-08-21 Thread Scott Marlowe
On 8/21/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi Medi, > Last night, I wrote a function which perfoms a subset of queries and returns > the results of a temporary table. It's more fast than I believe and that's > ok to me. > There is a prolem : It works too fine. I'm afraid of Murphy

Re: [ADMIN] how to call sql code without function

2007-08-21 Thread giuseppe . derossi
t my present learning I perform 9 calls.Giu- Original Message Da: Scott Marlowe < > [EMAIL PROTECTED]>    To: Medi Montaseri <[EMAIL PROTECTED]>Cc: [email protected] > Oggetto: Re: [ADMIN] how to call sql code

Re: [ADMIN] how to call sql code without function

2007-08-20 Thread Medi Montaseri
learning I perform 9 calls. > > Giu > > - Original Message > Da: Scott Marlowe <[EMAIL PROTECTED]> > To: Medi Montaseri <[EMAIL PROTECTED]> > Cc: [email protected] > Oggetto: Re: [ADMIN] how to

Re: [ADMIN] how to call sql code without function

2007-08-20 Thread giuseppe . derossi
Da: Scott Marlowe <[EMAIL PROTECTED]> To: Medi Montaseri <[EMAIL PROTECTED]> Cc: [email protected] Oggetto: Re: [ADMIN] how to call sql code without function Data: 20/08/07 20:05 > > > > On 8/20/07,

Re: [ADMIN] how to call sql code without function

2007-08-20 Thread Scott Marlowe
On 8/20/07, Medi Montaseri <[EMAIL PROTECTED]> wrote: > You can think of a database as a filesystem as well. That is do some > processing, store the result in temp table, do some more, etc,etc then merge > and process temp tables to arrive at some result. > > Just as in the case of filesystem, if y

Re: [ADMIN] how to call sql code without function

2007-08-20 Thread Medi Montaseri
You can think of a database as a filesystem as well. That is do some processing, store the result in temp table, do some more, etc,etc then merge and process temp tables to arrive at some result. Just as in the case of filesystem, if you are operating in a concurrent evironment, you need to fence

[ADMIN] how to call sql code without function

2007-08-20 Thread giuseppe . derossi
Hi all, I use Postgresql 8.2 in win env. I wrote a set of complex queries which return three temporary tables of results. I want to use then in php, but the unique way I know consists on sending one query a time via php, the logic I need has now been cablated into the sql code. I could use the fu