A number of people have suggested that there should be an int4(bool)
conversion function, but no one's got round to actually writing it.
Presumably the behavior ought to be
false => 0
true => 1
NULL => NULL
regards, tom lane
Next:From: Donald BauerDate: 2000-02-13 21:36:45
Subject: subscribe pgsql-sql-digest
Previous:From: email@example.comDate: 2000-02-13 00:31:25
Subject: Re: [SQL] Type casting bool?