How To Write A Comparison Expression

Hi,
i need a column in a SELECT statement which returns always "true" (As a boolean value, not as a string)

so I first tried

SELECT field1, field2, true AS field3

but this is not working. If I use "0 AS field3" this returns fine the 0, but this is not a boolean but a int.
I also tried to make something like

    "0 = 0 AS field"

but also errors. In that context I discoverd that I could not compare values in the select field - I can use +,-+,* ... for having something like "2 * field1 AS field3" but I'm not clever enough to figure out how I would have a field "field1 < 12 AS field3" (ok I would use CASE, but I need the boolean return value...)

Any ideas?
Thanks in advance,
Klaus



how could I write something