agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedBool types
2+ messages / 2 participants
[nested] [flat]
* Bool types
@ 1994-08-19 14:15 Quandt Brian <quandt@eec.umr.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Quandt Brian @ 1994-08-19 14:15 UTC (permalink / raw)
To: legacy
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.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Bool types
@ 1994-08-19 18:26 Paul M. Aoki <aoki@cs.berkeley.edu>
parent: Quandt Brian <quandt@eec.umr.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1994-08-19 18:26 UTC (permalink / raw)
To: Quandt Brian <quandt@eec.umr.edu>; +Cc: legacy
Quandt Brian <quandt@eec.umr.edu> writes:
> Okay I give up what are valid "values " for boolean types?
't' and 'f' (or "t"::bool and "f"::bool).
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
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.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-08-19 18:26 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-08-19 14:15 Bool types Quandt Brian <quandt@eec.umr.edu>
1994-08-19 18:26 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox