pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
binary operators
6+ messages / 6 participants
[nested] [flat]

* binary operators
@ 2001-01-30 15:12  Frederic Metoz <metoz@lmes.ibs.fr>
  0 siblings, 4 replies; 6+ messages in thread

From: Frederic Metoz @ 2001-01-30 15:12 UTC (permalink / raw)
  To: pgsql-sql

Hello,

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

Tanks,

Fred





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: binary operators
@ 2001-01-31 01:00  Christopher Sawtell <csawtell@xtra.co.nz>
  parent: Frederic Metoz <metoz@lmes.ibs.fr>
  3 siblings, 0 replies; 6+ messages in thread

From: Christopher Sawtell @ 2001-01-31 01:00 UTC (permalink / raw)
  To: Frederic Metoz <metoz@lmes.ibs.fr>; pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: binary operators
@ 2001-01-31 06:28  Ken Corey <ken@kencorey.com>
  parent: Frederic Metoz <metoz@lmes.ibs.fr>
  3 siblings, 0 replies; 6+ messages in thread

From: Ken Corey @ 2001-01-31 06:28 UTC (permalink / raw)
  To: Frederic Metoz <metoz@lmes.ibs.fr>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: binary operators
@ 2001-02-02 14:46  Peter Eisentraut <peter_e@gmx.net>
  parent: Frederic Metoz <metoz@lmes.ibs.fr>
  3 siblings, 1 reply; 6+ messages in thread

From: Peter Eisentraut @ 2001-02-02 14:46 UTC (permalink / raw)
  To: Frederic Metoz <metoz@lmes.ibs.fr>; +Cc: pgsql-sql

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/




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: binary operators
@ 2001-02-02 17:11  KuroiNeko <evpopkov@carrier.kiev.ua>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 6+ messages in thread

From: KuroiNeko @ 2001-02-02 17:11 UTC (permalink / raw)
  To: pgsql-sql

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.


--

 ÌĤ¯Ç­¤ÏÁͤòÊá¤é¤Ì




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: binary operators
@ 2001-02-14 12:22  Jaros³aw B³¹d <Jaroslaw.Blad@e-point.pl>
  parent: Frederic Metoz <metoz@lmes.ibs.fr>
  3 siblings, 0 replies; 6+ messages in thread

From: Jaros³aw B³¹d @ 2001-02-14 12:22 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2001-02-14 12:22 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
2001-01-31 01:00 ` Christopher Sawtell <csawtell@xtra.co.nz>
2001-01-31 06:28 ` Ken Corey <ken@kencorey.com>
2001-02-02 14:46 ` Peter Eisentraut <peter_e@gmx.net>
2001-02-02 17:11   ` KuroiNeko <evpopkov@carrier.kiev.ua>
2001-02-14 12:22 ` Jaros³aw B³¹d <Jaroslaw.Blad@e-point.pl>

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