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°
