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 > > 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 really what you > want, but in this case I > think boolean is right. > PS - if you get error messages again, please let us > know what version and > client you are using (e.g. PostgreSQL v7.2.1 from > jdbc) > > > strSql = " Update parts Set name = ? , description > = ? > > world_market = ?, part = ? , unit_of_measure = ? > > Where depot= ?; > > > > prepStmt = conn.prepareStatement(strSql); > > prepStmt.setString( 1, Pname) ; > > prepStmt.setString( 2, Pdesc) ; > > prepStmt.setBoolean(3, BoolWM) ; > [snip] > > SQLError ERROR: Unable to identify an operator > '~~' > > for types 'boolean' and 'unknown' > > You will have to retype this query using an > explicit > > cast > > Are you sure this error goes with this query? I > don't see any use of LIKE here > (which is what ~~ does for you). > > > I know, somewhere i m making mistake, but where?? > > Moreover, if i m updating the database with the > above > > query, the db is giving the error and deleting the > > data from the db. As per my understanding it > should > > automatically rollback. What is the problem??? > > I find this unlikely. If Postgresql was in the habit > of deleting data without > being asked to there'd be mention of it. I suggest > you turn query logging on > (in your postgresql.conf file) while you try to > reproduce this. That will > show you what is really happening. > > > What are the other coding rules for Postgres?? > > Manuals are at http://www.postgresql.org/ > Extra info at http://techdocs.postgresql.org/ > (including some online books) > Mailing lists you know about. > > -- > Richard Huxton > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
