[SQL] Regarding boolean datatype

2002-12-05 Thread kanika singh
Hello all, this is my first interaction with this list. I have a problem. I was using MSSQL Server as db, now i m changing to Postgres. I know that the bit type in MSSQLserver is boolean in Postgres. So, i have the following query and getting the following error:Why??? strSql = " Update parts

Re: [SQL] Backend message type 0x50 arrived while idle

2002-12-05 Thread Thrasher
Hi Phil It also happened to me last week. I found the problem is that you cannot share the same connection among processes unless you implement some kind of locking (semaphores, ...). More clearly, I had this problem. Query QA lasts 5 seconds to perform, and returns answer AA. Query QB lasts 1

Re: [SQL] Query about table and catalog

2002-12-05 Thread Christoph Haller
> I've got a table with several fields. Among others there are the fields > 'soil1', 'soil2', and 'soil3' that are char type. A row can have an empty > value in one of these fields, or the three fields can have valid values: > > cod_grass |suelo1|suelo2 | suel

Re: [SQL] Regarding boolean datatype

2002-12-05 Thread Richard Huxton
On Thursday 05 Dec 2002 9:11 am, kanika singh wrote: > Hello all, > > this is my first interaction with this list. I have a > problem. I was using MSSQL Server as db, now i m > changing to Postgres. I know that the bit type in > MSSQLserver is boolean in Postgres. There's also a bit type if that's

Re: [SQL] Regarding boolean datatype

2002-12-05 Thread kanika singh
Thanks for the reply. I will definitely look into it. and will come back to you. thanks and regards, Kanika --- Richard Huxton <[EMAIL PROTECTED]> wrote: > On Thursday 05 Dec 2002 9:11 am, kanika singh wrote: > > Hello all, > > > > this is my first interaction with this list. I > have a > > proble

Re: [SQL] master-detail relationship and count

2002-12-05 Thread Ross J. Reedstrom
On Fri, Nov 29, 2002 at 02:39:50PM +, Gary Stainburn wrote: > I've worked out a way of doing it by vreating a view for the tally info as: > > create view link_tally as > select lklid, lktype, count(*) from links group by lklid, lktype; > > and then doing: > > select r.rtid, r.rtname, l.cou