Thread

1. binary operators

   Frederic Metoz <metoz@lmes.ibs.fr> — 2001-01-30T15:12:17Z

   Hello,
   
   I am looking for the binary AND and OR ... SHIFT as well.
   Do they exist for postgresql ?
   
   Tanks,
   
   Fred
   
   
   
   

2. Re: binary operators

   Christopher Sawtell <csawtell@xtra.co.nz> — 2001-01-31T01:00:23Z

   On Wed, 31 Jan 2001 04:12, Frederic Metoz wrote:
   > Hello,
   >
   > I am looking for the binary AND and OR ... SHIFT as well.
   > Do they exist for postgresql ?
   
   AND and OR ..... yes.
   SHIFT .... I don't think so.
   
   -- 
   Sincerely etc.,
   
    NAME       Christopher Sawtell
    CELL PHONE 021 257 4451
    ICQ UIN    45863470
    EMAIL      csawtell @ xtra . co . nz
    CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
   
    -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
   
   
   

3. Re: binary operators

   Ken Corey <ken@kencorey.com> — 2001-01-31T06:28:08Z

   Frederic Metoz wrote:
   > I am looking for the binary AND and OR ... SHIFT as well.
   > Do they exist for postgresql ?
   
   Depending on what you're doing...you might get away with using
   mathematical operators to accomplish the above...
   
   A right SHIFT would be dividing by 2.  A left shift would be multiplying
   by 2.  
   
   I don't know off the top of my head about AND and OR.  Doesn't the
   manual cover this?
   
   -Ken
   
   

4. Re: binary operators

   Peter Eisentraut <peter_e@gmx.net> — 2001-02-02T14:46:44Z

   Frederic Metoz writes:
   
   > I am looking for the binary AND and OR ... SHIFT as well.
   > Do they exist for postgresql ?
   
   in 7.1
   
   -- 
   Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
   
   
   

5. Re: binary operators

   KuroiNeko <evpopkov@carrier.kiev.ua> — 2001-02-02T17:11:36Z

   Frederic Metoz writes:
   
   > I am looking for the binary AND and OR ... SHIFT as well.
   > Do they exist for postgresql ?
   
    I have  functions that  do this  on int4. Not  operators, but  better than
   nothing :)  Anyone interested,  please feel  free to  email in  private. In
   fact, the lib is simple as a moo.
   
   
   --
   
    
   
   
   

6. Re: binary operators

   Jaros³aw B³¹d <jaroslaw.blad@e-point.pl> — 2001-02-14T12:22:23Z

   Frederic Metoz wrote:
   
   > Hello,
   >
   > I am looking for the binary AND and OR ... SHIFT as well.
   > Do they exist for postgresql ?
   >
   > Tanks,
   >
   > Fred
   
   In postgresql binary operators AND, OR ... don't exist, but you can
   simply extend postgresql by yours operators. You should use CREATE
   OPERATOR function. If you are interested in examples you can send me
   mail.
   
   --
   Jaroslaw Blad
   Lead Engineer
   mailto:jaroslaw.blad@e-point.pl
   e-point S.A. POLAND
   (22) 853 48 30 http://www.e-point.pl