Re: select

bingo,

thaks

On Sat, 23 Sep 2000, Stephan Szabo wrote:

> 
> I'd assume this would work:
> select * from table where booleanfield is null;
> 
> Stephan Szabo
> sszabo@bigpanda.com
> 
> On Sat, 23 Sep 2000, Jeff MacDonald wrote:
> 
> > how would i select all rows where a boolean value is neither
> > t nor f.. ?
> > 
> > ie if someone inserted without setting the boolean tag.
> 
> 

Jeff MacDonald,

-----------------------------------------------------
PostgreSQL Inc        | Hub.Org Networking Services
jeff@pgsql.com        | jeff@hub.org
www.pgsql.com        | www.hub.org
1-902-542-0713        | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick  : bignose