I am trying to use migrations to set up a boolean data type column in
postgresql. I have tried:
peopleTable.newColumn("c_isactive", java.sql.Types.BOOLEAN, 0, 0, 0, true, "");
or:
peopleTable.newColumn("c_isactive", 16, 0, 0, 0, true, "");
when I examine the pg table, c_isactive is a bytea data type.
maybe there is no way to get to the boolean type?
what I'm looking for is:
CREATE TABLE t_people (c_isactive bool, c_note text);
any ideas what I am doing wrong. also interesting, when I google on
java.sql.Types, there is no boolean type listed in any of the referenced pages.
I'd love to hear that I am just doing something wrong.
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
