Optimizer & boolean syntax

Are those two syntaxes eqivalent ?

select * from users where monitored;
select * from users where monitored=true;

If the answer is yes, the optimimer probably doesn't agree with you :)

Tested on RC1:

template1=# create table a (a boolean, b text);
CREATE TABLE


.... inserted ~18000 rows with just one true (just to make an index scan  meaningful)....

template1=# vacuum analyze a;
VACUUM
template1=# explain select * from a where a;                     QUERY PLAN
---------------------------------------------------- Seq Scan on a  (cost=0.00..802.64 rows=1 width=11)   Filter: a
(2 rows)

template1=# explain select * from a where a=true;                          QUERY PLAN
-------------------------------------------------------------- Index Scan using a_a on a  (cost=0.00..2.01 rows=1
width=11)  Index Cond: (a = true)
 
(2 rows)

Bye!

--  Daniele Orlandi Planet Srl