agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Robert.Patrick@cs.cmu.edu
To: postgres@postgres.Berkeley.EDU
Subject: Using UNIQUE with classes with boolean attributes
Date: Mon,  3 Oct 1994 15:11:42 -0400 (EDT)
Message-ID: <4iY5Rim00hMdIUgFFy@cs.cmu.edu> (raw)

I am trying to execute "retrieve unique" queries on classes which have a
boolean attribute but I keep receiving the following warning

NOTICE:Oct  3 12:53:06:there is no operator < for types bool and bool
NOTICE:Oct  3 12:53:06:You will either have to retype this query using an
NOTICE:Oct  3 12:53:06:explicit cast, or you will have to define the operator
WARN:Oct  3 12:53:06:< for bool and bool using DEFINE OPERATOR
  
What do I need to do to make this work properly?

Thanks,
Robert

==============================================================================
   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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: Robert.Patrick@cs.cmu.edu
  Subject: Re: Using UNIQUE with classes with boolean attributes
  In-Reply-To: <4iY5Rim00hMdIUgFFy@cs.cmu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox