migrations and boolean values
migrations and boolean values
- Subject: migrations and boolean values
- From: email@hidden
- Date: Wed, 27 Aug 2008 07:59:46 -0700 (PDT)
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden