is there any way to perform a query that returns 1 or 0, but parse it as boolean in the generated mo...

# squarelibraries

[myanmarking]

is there any way to perform a query that returns 1 or 0, but parse it as boolean in the generated model ?

[Benoit Quenaudon]

define the field as "INTEGER AS BOOL" and all the query will use booleans

[myanmarking]

i’m not talking about table definition, that it works. I’m talking about the result of a query, not directly associated with the boolean column. And that result is an int, but i want to parses to think it as a boolean. The real question probably, you cannot use ‘AS BOOL’ in queries can you ?

[myanmarking]

SELECT 1 AS BOOL (thats what i was asking). Because i know if you do ‘SELECT boolColumns FROM xxxx’ it works

[Alex Nabrozidis]

does it work if you do SELECT integerColumn = 1 FROM ... ?

[Alex Nabrozidis]

I've used COUNT(*) > 0 in the past and it worked as expected (returns a boolean)

[myanmarking]

good point. I’ll check later. Thanks!