From: Richard Huxton <dev@archonet.com>
To: kanika singh <kanikasingh20@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Regarding boolean datatype
Date: Thu, 5 Dec 2002 10:29:59 +0000
Message-ID: <200212051029.59648.dev@archonet.com> (raw)
In-Reply-To: <20021205091110.58690.qmail@web14512.mail.yahoo.com>
References: <20021205091110.58690.qmail@web14512.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, kanikasingh20@yahoo.com
Subject: Re: Regarding boolean datatype
In-Reply-To: <200212051029.59648.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox