Re: Boolean test

> I can't see why my sql here is throwing an error,
> SELECT *
> FROM plan_template
> WHERE public = true;
>
> The field public is 'boolean'

That should work perfectly...

> I've also tried :
> WHERE public = 'true';
^^^ Won't work (I think)
> WHERE public = t;
^^^ Won't work (I think)
> WHERE public = 't';
^^^ Will work
> WHERE public = 'Yes';
^^^ Won't work (I think)

However, the cleanest way to do it is like this:

SELECT *
FROM plan_template
WHERE public;

Since none of the above are working for you, I think there's something wrong
with your schema...

Chris