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
