Re: Re : Re : Re : Re : [GENERAL] Select in temporary table

2010-04-01 Thread Alban Hertroys
On 1 Apr 2010, at 10:47, Sylvain Lara wrote: > De : jose javier parra sanchez > Cc : pgsql-general@postgresql.org > Envoyé le : Jeu 1 avril 2010, 9 h 26 min 27 s > Objet : Re: Re : Re : Re : [GENERAL] Select in temporary table > > Not sure about how de C# driver you use to c

Re : Re : Re : Re : [GENERAL] Select in temporary table

2010-04-01 Thread Sylvain Lara
unction not exists...'; > END IF; > > -- Select from myTableTemp > SELECT COUNT(distinct pat_id) INTO nbLines FROM instance_fiche WHERE > inst_id IN (select inst_id from myTableTemp); > > > RETURN nbLines; > > EXCEPTION > WHEN

Re: Re : Re : Re : [GENERAL] Select in temporary table

2010-04-01 Thread jose javier parra sanchez
Not sure about how de C# driver you use to connect, but if you have multiple connections, then you have multiple sessions. 2010/4/1 Sylvain Lara : >> Hello, >> >> I found some subjects like mine on many forums, but the given solution >> doesn't work for me. >> >> I'm using PostgreSQL 8.4. I'm work

Re : Re : Re : [GENERAL] Select in temporary table

2010-04-01 Thread Sylvain Lara
> Hello, > > I found some subjects like mine on many forums, but the given solution > doesn't work for me. > > I'm using PostgreSQL 8.4. I'm working on a C# application. > > When connecting to the application, a temporary table myTableTemp is created. > This table is available for all the appli

Re : Re : [GENERAL] Select in temporary table

2010-04-01 Thread Sylvain Lara
> Hello, > > I found some subjects like mine on many forums, but the given solution > doesn't work for me. > > I'm using PostgreSQL 8.4. I'm working on a C# application. > > When connecting to the application, a temporary table myTableTemp is created. > This table is available for all the appl

Re : [GENERAL] Select in temporary table

2010-03-31 Thread Sylvain Lara
> Hello, > > I found some subjects like mine on many forums, but the given solution > doesn't work for me. > > I'm using PostgreSQL 8.4. I'm working on a C# application. > > When connecting to the application, a temporary table myTableTemp is created. > This table is available for all the appl

Re: [GENERAL] Select in temporary table

2010-03-31 Thread Bill Moran
In response to Sylvain Lara : > Hello, > > I found some subjects like mine on many forums, but the given solution > doesn't work for me. > > I'm using PostgreSQL 8.4. I'm working on a C# application. > > When connecting to the application, a temporary table myTableTemp is created. > This table

[GENERAL] Select in temporary table

2010-03-31 Thread Sylvain Lara
Hello, I found some subjects like mine on many forums, but the given solution doesn't work for me. I'm using PostgreSQL 8.4. I'm working on a C# application. When connecting to the application, a temporary table myTableTemp is created. This table is available for all the application duration, a