Home > Archive > PostgreSQL JDBC > April 2005 > Re: smallint vs. boolean (was invalid string enlargement









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: smallint vs. boolean (was invalid string enlargement
Glenn Holmer

2005-04-13, 11:24 am

On Wed, 2005-04-13 at 10:09 +1200, Oliver Jowett wrote:

> Change the column type so it is a boolean, change the hibernate mapping
> so it calls setShort(), or create the implicit cast as I suggested.


I got it to work with some PL/pgSQL functions, implicit casts, and
overloading the = operator (smallint, boolean). I'll strongly recommend
to the vendor that they rewrite the Postgres DDL for their product to
use booleans for boolean fields, but in the mean time are there any side
effects I should worry about?

--
____________________
____________________
____________________

Glenn Holmer gholmer@weycogroup.com
Software Engineer phone: 414-908-1809
Weyco Group, Inc. fax: 414-908-1601



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com