Hello,

I really just want to know specifically whether

SELECT * FROM test WHERE boolean_column;
SELECT * FROM test WHERE integer_column;

work or not.

Can anyone please run this on some test table, please? I don't want to
download, install, and uninstall PostgreSQL only for running a single
statement.

TIA
Karsten

On 18 Jul., 15:52, Karsten Wutzke <kwut... (AT) web (DOT) de> wrote:
The above obviously works:
http://www.postgresql.org/docs/8.1/s...e-boolean.html

This is not surprising.

Can anyone please run

SELECT * FROM test WHERE integer_column;

please?

Karsten

Karsten Wutzke wrote:
No i do not work.
But you can do

SELECT * FROM test WHERE bool(integer_column);

/Jens Henrik

Karsten Wutzke ha scritto:
db_atm=# create table test(b bool, i int);
CREATE TABLE
db_atm=# insert into test (b, i) values (true, 1);
INSERT 0 1
db_atm=# insert into test (b, i) values (true, 2);
INSERT 0 1
db_atm=# insert into test (b, i) values (true, 0);
INSERT 0 1
db_atm=# select * from test where b;
b | i
---+---
t | 1
t | 2
t | 0
(3 rows)

db_atm=# select * from test where i;
ERROR: argument of WHERE must be type boolean, not type integer
db_atm=# select * from test where i::bool;
b | i
---+---
t | 1
t | 2
(2 rows)

db_atm=# drop table test;
DROP TABLE
db_atm=#