pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedbinary operators
6+ messages / 6 participants
[nested] [flat]
* binary operators
@ 2001-01-30 15:12 Frederic Metoz <metoz@lmes.ibs.fr>
2001-01-31 01:00 ` Re: binary operators Christopher Sawtell <csawtell@xtra.co.nz>
2001-01-31 06:28 ` Re: binary operators Ken Corey <ken@kencorey.com>
2001-02-02 14:46 ` Re: binary operators Peter Eisentraut <peter_e@gmx.net>
2001-02-14 12:22 ` Re: binary operators Jaros³aw B³¹d <Jaroslaw.Blad@e-point.pl>
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-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
@ 2001-01-31 01:00 ` Christopher Sawtell <csawtell@xtra.co.nz>
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-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
@ 2001-01-31 06:28 ` Ken Corey <ken@kencorey.com>
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-01-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
@ 2001-02-02 14:46 ` Peter Eisentraut <peter_e@gmx.net>
2001-02-02 17:11 ` Re: binary operators KuroiNeko <evpopkov@carrier.kiev.ua>
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-01-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
2001-02-02 14:46 ` Re: binary operators Peter Eisentraut <peter_e@gmx.net>
@ 2001-02-02 17:11 ` KuroiNeko <evpopkov@carrier.kiev.ua>
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-01-30 15:12 binary operators Frederic Metoz <metoz@lmes.ibs.fr>
@ 2001-02-14 12:22 ` Jaros³aw B³¹d <Jaroslaw.Blad@e-point.pl>
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