Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA12705 for postgres-redist; Fri, 19 Aug 1994 07:16:45 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199408191416.HAA12705@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from umr.edu (hermes.cc.umr.edu [131.151.1.68]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id HAA12695 for ; Fri, 19 Aug 1994 07:16:42 -0700 Received: from eec.umr.edu (umrgec7.eec.umr.edu [192.65.97.43]) via SMTP by hermes.cc.umr.edu (8.6.9/E.3.01) id JAA11246; Fri, 19 Aug 1994 09:16:30 -0500 Received: from umrgec8.eec.umr.edu (umrgec8.eec.umr.edu [192.65.97.44]) via ESMTP by umrgec7.eec.umr.edu (8.6.9/D.3.00) id JAA07672; Fri, 19 Aug 1994 09:25:04 -0500 From: Quandt Brian Received: from (quandt@localhost) by umrgec8.eec.umr.edu (8.6.9/M.3.01) id JAA03717; Fri, 19 Aug 1994 09:15:29 -0500 Message-Id: <199408191415.JAA03717@umrgec8.eec.umr.edu> Subject: Bool types To: postgres@postgres.Berkeley.EDU Date: Fri, 19 Aug 1994 09:15:29 -0500 (CDT) X-Mailer: ELM [version 2.4 PL21] Content-Type: text Content-Length: 446 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Fri, 19 Aug 94 07:16:45 -0700 Resent-XMts: smtp Okay I give up what are valid "values " for boolean types? As in retrieve (XXX.all) where XXX.booltype = true or retrieve (XXX.all) where XXX.booltype = false or append XXX (booltype = what) I know that bools are either true or false but I just don't know how postgres (4.2) indicates these. Everytime I try things like boolvar = 1 to indicate true in the where clause I get illegal op for int4... need to cast it. Brian Quandt ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================