Subject | RE: [firebird-support] What about: New Buil-in function Bool() or Boolean() or BoolCast() |
---|---|
Author | sasha |
Post date | 2007-08-06T15:45:12Z |
> ...But...I don't know about your users, but mine are equally puzzles by 0/1, Y/N,
>
> if you make an offhand report, your user dont know 0 and 1
> against natural language characters ;)
>
T/F, Yes/No or whatever I give them :)
IMHO if you need to make offhand reports format your values to suite your
users' needs with simple sql like
case when bool_col = 1 then 'T' when bool_col = 0 then 'F' else 'unknown'
end or something similiar...
Introducing the function you proposed wouldn't solve anything on a global
level and you can solve the problem with UDFs, you can create lookup table
for booleans, v2.1 has, I believe, decode function which with you will be
able to shorten the above example... So many good choices...
Sasha