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