Re: convert integer to bool implicitly

Sim Zacks <sim@compulab.co.il> schrieb:

> How easy would it be to write a small type extension to have integer
> automatically convert to bool?
> For example, I want an implicit conversion that 0 is false and everything
> else is true.

test=# \d foo;
      Table "public.foo"
 Column |  Type   | Modifiers
--------+---------+-----------
 val    | integer |

test=# select * from foo;
 val
-----
   0
   1
   2
   3
(4 rows)

test=# select val::bool from foo;
 val
-----
 f
 t
 t
 t
(4 rows)


> Is this C programming or can you do it with a local procedural language?

You can use regular casts.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°