i'd like to see an "is not" operator
something like:
'!NAME' => undef # COLUMN IS NOT NULL
under postgres, booleans behave as such:
example table
create table test ( id integer not null , is_selected boolean );
insert into test ( id , is_selected ) values ( 1 , NULL );
insert into test ( id , is_selected ) values ( 2 , true );
insert into test ( id , is_selected ) values ( 3 , false );
get them all:
select * from test;
returns: 1,2,3
get not true:
select * from test where is_selected is not true;
returns 1,3
get not false:
select * from test where is_selected is not false;
returns 1, 2
current rose support can't do that. the closest it gets is this:
select * from test where is_selected <> false ;
returns 2
select * from test where not(is_selected = false) ;
returns 2
that said, if the following two OP could be added to query builder:
is not
is ( just for standardization )
that would be great :)
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
