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] 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

[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